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
Bookmarks