Hi all,
I have a long list of cells that have dates and times in them with the format of '6/1/20 9:15:30 AM' etc. There may be multiple cells with the same date but different times. I am trying to get the earliest time stamp of these duplicate dates. For example:
I want the earliest 6/3 and 6/5. Caveat here is I have a column of data to the left that needs to be maintained for VLOOKUP purposes (as you'll see in the attached file). Not sure how to accomplish this or if it is even possible - the 'remove duplicates' option I don't think can apply here.Please Login or Register to view this content.
Thanks!
Bookmarks