#1
|
|||
|
|||
return the status description relating to the latest date in
Can anyone help with this one please?
I have attached a spreadsheet with the example of my problem. The spreadsheet has: * a row (2) of 'Status Description' headings * columns (C-J) with dates of each occurrence of each status for a specific Job No. * a column (L) showing the 'Latest date' I need a formula to return the 'status description' (as text) relating to the latest date in Col 'L' i.e. in cell 'M4', I need a formula that the latest date (09/07/2018) relates to the 'Status description' "Job Completed" It's probably a simple answer, but I'm a novice at this. If anyone can help, I would be grateful. |
#2
|
||||
|
||||
Something like this?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Late status based on end date | gerhardstru | Project | 0 | 08-03-2018 01:09 AM |
EVM calculate % completed after status date | kevenang | Project | 2 | 11-17-2017 06:06 PM |
Status Date in a Report | ebilbrough | Project | 3 | 03-09-2017 09:45 AM |
Lookup & Import Earliest/Latest Date for Activity? | ekeithjohnson | Excel | 1 | 08-25-2014 09:24 AM |
Meaning of current date vs status date when saving baselines | ketanco | Project | 1 | 02-08-2012 02:20 PM |