LUIS FREUND
asked on
Latest date in Excel
Wanted to get latest date from column B that is not 100% in column A. See highlighted yellow in attachment.
C--Users-lfreund-Desktop-LATEST-DAT.xlsx
C--Users-lfreund-Desktop-LATEST-DAT.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Neeraj, that will return an error if the max date is listed twice.
I don't think so though I Just tested it after replacing old dates with the same max date.
Can you please let me know the scenario when the proposed formula returned an error?
Actually my proposed formula is the regular version of your array formula.
Also, it's better to avoid the whole column reference when comparative operators are used.
Can you please let me know the scenario when the proposed formula returned an error?
Actually my proposed formula is the regular version of your array formula.
Also, it's better to avoid the whole column reference when comparative operators are used.
Sorry, I got caught out by the dodgy date formats again. I typed "2/21/18" into another cell and your formula returned #VALUE! but mine didn't. Entering the date in the correct format (d/mm/yy) didn't cause any issues though.
Also, it's better to avoid the whole column reference when comparative operators are used.
Maybe if there were hundreds of them, but it's only one formula.
You never know if OP is going to have multiple such formulas. :)
ASKER
Thank you very much guys....works great! I failed to mention that I wanted the latest date based on a criteria as well and will close this question out and ask it with the criteria.
You're welcome Luis! Glad we could help.