From B3:O402 I have a range of values, each cell D have a specific date related to its own row. Example D4 is related to B4:O4.
After putting a Initial Date in D1 and a Final Date in F1, the formula must identify the range of cells related to those dates.
I need a formula to identify and show the address of this range of cells related to those dates.
I attached a workbook with an example.
Last edited by Mr.Castle; 09-09-2019 at 03:25 PM.
Do you want string returned?
If so...
="B"&MATCH(D1,D4:D402,0)+3&":O"&AGGREGATE(14,6,ROW(D4:D402)/(D4:D402=F1),1)
Alternately:
="B"&AGGREGATE(15,6,ROW(D4:D402)/(D4:D402=D1),1)&":O"&AGGREGATE(14,6,ROW(D4:D402)/(D4:D402=F1),1)
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
The formula worked , well.
Thank you , CK76
You are welcome and thanks for the rep
If your query is answered, please mark the thread as solved, using thread tool found at top of your initial post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks