chakkrav
04-08-2017, 02:36 PM
Hi,
I have multiple sheets, where in each sheet i need to check 4 non contiguous columns (different in sheet) for unique combination. After concatenating the 4 cols, If its not unique i.e. if it is duplicate highlight them as & throw a message saying the respective 4 columns values are not unique.
Attached is the sample file, which i'm currently manually doing a concatenation of the 4 cols & checking for duplicate records through conditional formatting.
Need help with a macro to perform the same in the background and throw a message to my users.
Highly appreciate if somebody has an solution to this issue.
I have multiple sheets, where in each sheet i need to check 4 non contiguous columns (different in sheet) for unique combination. After concatenating the 4 cols, If its not unique i.e. if it is duplicate highlight them as & throw a message saying the respective 4 columns values are not unique.
Attached is the sample file, which i'm currently manually doing a concatenation of the 4 cols & checking for duplicate records through conditional formatting.
Need help with a macro to perform the same in the background and throw a message to my users.
Highly appreciate if somebody has an solution to this issue.