Formula to Find the Most Recent Date, and Then Return the Corresponding Cell
I'm working on this sheet to track the actions done by different groups while registering a new company. there is no specific order for these groups to do their action, and there is no specific processor to do the action.
The column that need the formula is called "Most Recent Processor". it should show the name of the processor who has done the most recent action based on the date cell next to his name.
To understand the issue clearly, please see attached excel sheet
Tracking.xlsx
Please help!
You can use the =Max function to find the latest Date.. What would you want to do after you get the latest date?
Cheers!
Deep Dave
Put this in H2:
=LOOKUP(I2;B2:G2;A2:F2)
and this in I2:
=MAX(C2;E2;G2)
and drag both down
btw maybe my semicolons have to be commas for you
When I say semicolon, u say comma!
Hold up there's some wrong results in there...
Instead of the lookup formula i gave you for H2, use this:
=IF(I2=C2;B2;IF(I2=E2;D2;IF(I2=G2;F2;"")))
and drag down
There should be a shorter way, but this works. However if you actually have more than 3 processes and dates per sn, it gonna be a long, long formula...
Yes, there is. See post #6Originally Posted by L-Drr
awesome
I2: =max(c2:g2)
h2: =index(b2:f2,match(i2,c2:g2,0))
Awesome! It works great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks