IF Formula unique id and post newest date into status
Hi ALL,
Thank you for helping out with this formula. I have a set of unique ids and dates in x/xx/xxxx xx:xx:xx format. I would like to create a if formula that will send back a string labelled "new" in the status column if date is closest to today's date.
I am thinking if and max formula, but do not know how to.
Please see attachment
formulaifandmax.xlsx
Thank you,
Newb
Try this in D2 and fill down:
=IF(SUMPRODUCT(($A$2:$A$16=A2)*($B$2:$B$16>B2))=0,"New","Old")
- Moo
* You could also use the COUNTIFS function:
=IF(COUNTIFS($A$2:$A$16,"="&A2,$B$2:$B$16,">"&B2)=0,"New","Old")
Last edited by Moo the Dog; 03-16-2015 at 07:45 PM.
Thank you Moo! I seriously need to look more into sumproducts. I was thinking if(VLOOKUP with MAX Date).
-Newb
Glad to help, and thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks