Hi All,
What would be the best way to find the duplicates using values from multiple columns.
Example : Concatenate value of columns A & B & C & D & G and find if this combination is repeated across the sheet and return/highlight value of Column A. (The sheet is large like 50,000 rows).
Thanks for your valuable help and time as always
What would be the best way to find the duplicates using values from multiple columns.
Example : Concatenate value of columns A & B & C & D & G and find if this combination is repeated across the sheet and return/highlight value of Column A. (The sheet is large like 50,000 rows).
Thanks for your valuable help and time as always
