I would like to compare 2 separate columns and list out unique rows in another sheet.
I would like the code to compare Column 1 and Column 5 and list on another sheet the data from those rows.
I can find tons of stuff that compares the two rows as if they contained the same data, but nothing if contains different data. Also, ignoring the 3 columns in the creates other issues. Thanks for the help.
Column 1 Column 2 Column 3 Column 4 Column 5 MOW204000235 1 No No Vehicle Maint. MOW204000235 1 Yes No Driver Fitness MOW204000235 1 No Yes Vehicle Maint. OH3260013363 3 Yes No Driver Fitness OH3260013363 3 Yes No Driver Fitness MOW204000155 1 No Yes Vehicle Maint. MOW204000155 1 No No Unsafe Driving MOW204000155 1 Yes Yes Driver Fitness MOW204000155 1 No Yes Driver Fitness
Column 1 Column 2 MOW204000235 Vehicle Maint. MOW204000235 Driver Fitness OH3260013363 Driver Fitness MOW204000155 Vehicle Maint. MOW204000155 Unsafe Driving MOW204000155 Driver Fitness