The title is a mouthful but hear me out.
I'm capturing people entering a venue. The individual's unique identifier is their phone number (column D).
What I want to do is;
look for the duplicates in column D,
then look at column G and identify which time is earlier,
with the result in column H - 1 for the first entry, 2 for the second entry. There will never be more than 2 entries per day.
To be honest, I don't even know where to start with this one, but I want to avoid VBA.
I've attached an example.
Matt
Bookmarks