Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-21-2018, 08:18 AM
garymon9AX garymon9AX is offline return the status description relating to the latest date in Windows 10 return the status description relating to the latest date in Office 2013
Novice
return the status description relating to the latest date in
 
Join Date: Feb 2018
Posts: 9
garymon9AX is on a distinguished road
Default 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.
Attached Files
File Type: xlsx 'Latest Status' - Forum Query.xlsx (12.1 KB, 8 views)
Reply With Quote
  #2  
Old 08-21-2018, 09:35 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline return the status description relating to the latest date in Windows 7 64bit return the status description relating to the latest date in Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Something like this?
Attached Files
File Type: xlsx 'Latest Status' - Forum Query.xlsx (8.4 KB, 11 views)
__________________
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
Reply With Quote
  #3  
Old 08-21-2018, 10:02 AM
garymon9AX garymon9AX is offline return the status description relating to the latest date in Windows 10 return the status description relating to the latest date in Office 2013
Novice
return the status description relating to the latest date in
 
Join Date: Feb 2018
Posts: 9
garymon9AX is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
Something like this?
Thanks Pecoflyer, that worked a treat.
Reply With Quote
Reply

Thread Tools
Display Modes


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
return the status description relating to the latest date in Status Date in a Report ebilbrough Project 3 03-09-2017 09:45 AM
return the status description relating to the latest date in Lookup & Import Earliest/Latest Date for Activity? ekeithjohnson Excel 1 08-25-2014 09:24 AM
return the status description relating to the latest date in Meaning of current date vs status date when saving baselines ketanco Project 1 02-08-2012 02:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft