Dear all,
I want to have a result of the header date when the latest set of 2 ends to where it ends i wana pick the header date but only if the latest cell is 1 than return the formula cell as empty as it has no value in the database.
Thanks in advance.
attached is the file for my data
Dear is there anyone out who could help me in that
Withdrawn. Misread instructions.
Dave
Try this.This requires that there are both 1s and 2s in the row. If either is missing this won't work.Formula:
Please Login or Register to view this content.
Not sure if this is what you are trying to achieve...
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Row numbers 3 & 6 are ending with 1, but dates not taken.
Row number 4 isending with 2, but dates taken.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks