|
|
#1
08-21-2018, 08:18 AM
|
|||
|
|||
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
08-21-2018, 09:35 AM
|
||||
|
||||
|
Something like this?
__________________
Using O365 v2503 - 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
08-21-2018, 10:02 AM
|
|||
|
|||
|
Quote:
|
|
|
|
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 |
Windows 10 
Office 2013
Linear Mode
