I would like to see a VBA function which will identify whether we have any duplicates in a combination of columns.
For Eg:, in below dataset, column A and column C need to have unique values.
id ColumnA ColumnB ColumnC ColumnD
1 A B C D
2 A1 B1 C1 D1
3 A2 B2 C2 D2
4 A1 B3 C1 D3 --> Value for column A and C duplicated with id 2
5 A4 B1 C4 D1 -->
6 A2 B1 C2 D1 --> Value for column A and C duplicated with id 3
and so on
I want to identify the IDs which are duplicated in the sheet for the Column A and Column C (combined).
How best can we achieve the same?