Hi I need some help doing something that is way over my head.
I need to compare data with the same location, time date and procedure which are in a row in different cells against the next row and if there is a match of all 4 cells then format.
Example below the 4th and 6th row are identical but I cannot get duplicates to compare across.
Line 8 has the same procedure but not the same date and time, i don't want that to highlight.
Any help would be appreciated. Al
Location Date Time Procedure
RAD *NA 03/07/2020 14:15 BN25ZZZ
RAD *NA 03/07/2020 14:15 BW211ZZ
RAD *NA 03/07/2020 14:15 BW29ZZZ
RAD *NA 03/07/2020 14:15 B3281ZZ
RAD *NA 03/11/2020 23:25 BW29ZZZ
RAD *NA 03/07/2020 14:15 B3281ZZ
RAD *NA 03/11/2020 23:25 BW29ZZZ
RAD *NA 03/11/2020 23:25 B3281ZZ
RAD *NA 03/16/2020 17:00 B24BZZZ
MSR 1 03/12/2020 11:47 0DJ08ZZ
MSR 2 03/14/2020 13:09 3E0G8GC
I need to compare data with the same location, time date and procedure which are in a row in different cells against the next row and if there is a match of all 4 cells then format.
Example below the 4th and 6th row are identical but I cannot get duplicates to compare across.
Line 8 has the same procedure but not the same date and time, i don't want that to highlight.
Any help would be appreciated. Al
Location Date Time Procedure
RAD *NA 03/07/2020 14:15 BN25ZZZ
RAD *NA 03/07/2020 14:15 BW211ZZ
RAD *NA 03/07/2020 14:15 BW29ZZZ
RAD *NA 03/07/2020 14:15 B3281ZZ
RAD *NA 03/11/2020 23:25 BW29ZZZ
RAD *NA 03/07/2020 14:15 B3281ZZ
RAD *NA 03/11/2020 23:25 BW29ZZZ
RAD *NA 03/11/2020 23:25 B3281ZZ
RAD *NA 03/16/2020 17:00 B24BZZZ
MSR 1 03/12/2020 11:47 0DJ08ZZ
MSR 2 03/14/2020 13:09 3E0G8GC