Is there a way to find out (not using concatenate) if a truck and its associated date exist further down in the columns?
For example: Truck 73 has a date of 01/01/2018 (and is duplicated at the bottom). What formula can I use to determine if that is duplicated down further in the columns?
Need a formula for Col C.
Col A Col B Col C
Truck date Duplicated?
73 1/1/2018 Yes
34 2/13/2013 No
90 2/24/2013 No
83 2/25/2013 No
40 1/16/2013 No
73 1/1/2018 Yes
Bookmarks