hello,
how to delete duplicate rows from excel based on duplicate data in multiple columns.
example:
col1 col2 col3 col4
val1 val2 val3 val4
val1 val2 val3 val5
val5 val7 val8 val9
so as per above example, bot needs to look for the duplicates in col2 and col3 data only and in result, it should only return last row. as val2 and val3 are duplicates in first two.
thanks.
how to delete duplicate rows from excel based on duplicate data in multiple columns.
example:
col1 col2 col3 col4
val1 val2 val3 val4
val1 val2 val3 val5
val5 val7 val8 val9
so as per above example, bot needs to look for the duplicates in col2 and col3 data only and in result, it should only return last row. as val2 and val3 are duplicates in first two.
thanks.