Conditional formating 2 columns unique criteria

[jaime1134]

Hello.
Im trying to clean up a large list of raw data for scientific reserch... the data table is about 40,000 rows long.
I have a column with timestamps.. column K
and i have a column with bird codes... column O

I need to remove duplicate values from K, ONLY if it is also duplicated in O...

So for example:

K O
time bird
157 j
157 j
157 m
157 m
897 h
897 m
1012 k
4587 h
6548 t
9687 t
25684 k
25684 k
25684 h
25684 k
25684 m
56486 h
58587 t
78987 m
78987 m
78987 k
78987 k
301564 t
879594 k
897562 p
897562 p

I want duplicate times highlighted ONly if their bird code is also duplicated
I can have more than one time unmarked as long as the bird codes are different

The list should end up like this:

K O
time bird
157 j
157 m
897 h
897 m
1012 k
4587 h
6548 t
9687 t
25684 k
25684 h
25684 m
56486 h
58587 t
78987 m
78987 k
301564 t
879594 k
897562 p

[BadlySpelledBuoy]

In the attached I've used the below as a conditional formatting formula:

Please Login or Register  to view this content.

Does that do what you need?

BSB

[jaime1134]

In the attached I've used the below as a conditional formatting formula:

Please Login or Register  to view this content.

Does that do what you need?

BSB

Thank you so much BSB... that is perfect. Have a great day!!!!

[BadlySpelledBuoy]

Happy to help mate.
Don't forget to mark the thread as SOLVED if you're happy your have a working solution.

Take care.

BSB