• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Return Multiple Row Header Based on 2 Date

Status
Not open for further replies.
In the picture below, all I've done is change the formatting (NOT the values).
Are you looking for data ON the two dates or between (inclusive) the two dates?
Either way your results are difficult to reverse engineer.
78475
More narrative required.
 
By the way, if you can't be bothered to answer questions people have asked to help solve your problem, nor even bothered to acknowledge responses, can you understand how people might no longer be bothered to help you?
 
Kenshin
Seems You didn't know how did You get that or those results?
Because that mystery B12 - I used below cell to get one sample result - as You noticed.
Many things could be possible, but without clear rules ...
 
Kenshin
Seems You didn't know how did You get that or those results?
Because that mystery B12 - I used below cell to get one sample result - as You noticed.
Many things could be possible, but without clear rules ...
The rule is if there is the number on range B2:F7 within 2 dates on columns header then return row header, hope its clear now
 
Kenshin
Case the 2nd date
... there are five numbers in within two dates ... if that 2nd data will be from February.
Maybe clear for You ...
 
Status
Not open for further replies.
Back
Top