Find duplicate rows where value of cell with time criteria is within 30 mins

Try this:-
This code will show results in column "E" on.

Please Login or Register  to view this content.

Regards Mick

Hi Mick

That's great! One thing: With example below Person4 on the 8th row is within 30 mins of Person4 on the 7th row, but not showing as Dupe - I guess because it's not within 30mins of the first Dup2 time? So rows 6, 7 and 8 should all be Dupes as shown by (Dup4). Appreciate this adds an extra layer of complexity! Thanks for your help! Emma

Date Time ID GateNo
23/09/2013 20:33 Person1 A45
23/09/2013 20:33 Person2 A45 Dup1
23/09/2013 20:33 Person3 A45
23/09/2013 20:33 Person4 A45 Dup2
23/09/2013 20:43 Person2 A45 Dup1
23/09/2013 20:23 Person4 A45 Dup2 (Dup4)
23/09/2013 20:13 Person4 A45 Dup2 (Dup4)
23/09/2013 20:02 Person4 A45 (Dup4)
23/09/2013 23:55 Person3 A22 Dup3
24/09/2013 00:15 Person3 A22 Dup3
23/09/2013 19:40 Person4 A45 (Dup4)

Try this:- This is better code.
The results need some interpretation, because for each set of unique "ID GateNo", the code looks at each time within the related set of times to find any others times that are within 30 min of the first time. Then it does the same for each susequent time in the set of related times.
As a Consequence you get these half related sets of dups.

Please Login or Register  to view this content.

Regards Mick

Sorry for late response...thank you so much for your help, I'm sure I can work with this!
Kind regards Emma

Thanks for your reply:-
The code below should give better results, as it checks each Unique person against each duplicate of that unique person and returns the results starting column "E" .
NB:- Your actual data is expected to start on row (2) , as per your thread data.

Please Login or Register  to view this content.

Regards Mick