I need to find a way to recognize duplicates in a excel spreadsheet. (Checking specific rows and columns)
For example, if a user has to enter date in A1, B2, C3, and D4 I want to check those columns to see if any of them match.
I am hoping to have something like this in a macro.
Can anyone help me?