# 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.

#### Attachments

• 10.9 KB Views: 5

#### rahulshewale1

##### Active Member
hi @mitz123 ,

try this ?

=IF(MAX(\$I\$2:\$I\$17)=I2,"Y","N")

#### 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)