Forum Discussion
Solved
Date Column Duplicates
I am fairly new to using excel and have a problem trying to find duplicate dates in a column for a specific value in another column. For example, in the column below, Jane has a duplicate date of ser...
Hi
If you wish to keep the original data then you can use the COUNTIFS formula in the screenshot below
Hi
If you wish to keep the original data then you can use the COUNTIFS formula in the screenshot below
If you add an IF condition before that formula Wyn indicated, you can fastly remove duplicates.
C2: IF(countifs($A$1:A2;A2)>1;"";A2)
C3: IF(countifs($B$1:B2;B2)>1;"";B2)
Then you have let's say a "copy" of columns A and B in columns C and D with blank rows if there's a duplicate. Now you copy columns C and D and paste them as values (special paste) in another sheet or on other columns or on whatever colums you want; now you delete all other columns and sort datas by date or by name or whatever.