• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Latest entry as per combination of date and time stamp (IST)

mitz123

New Member
Hey i am facing issue with excel working i need to mapp the word "LATEST ENTRY" against each scenario keeping the date and time stamp in mind, newest one to be given the tagging of "Latest Entry". I cannot remove any records from the data sets only to identify the latest one and tagg them. I tried using Max(if) function but result not coming as desired.

Please help. Its urgent.
 

Attachments

Peter Bartholomew

Well-Known Member
This is essentially the same formula except that I never use direct cell references
= N(STAMP=MAX(STAMP))
By deliberately leaving the logical result as {0,1}, I can both use a number format such as
"latest entry";;"";@
to determine the visual appearance of the result whilst still treating it as a Boolean in formulas.

To return the email address that corresponds to the latest entry one might use
= VLOOKUP( MAX(STAMP), IF( {1,0}, STAMP, CustomerEmail), 2, FALSE )
or, better, in MS365,
= XLOOKUP(MAX(STAMP), STAMP, CustomerEmail)
 
Top