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,
You might like to remove the duplicate in this table, so please select any cell in the table, then go to:
Data (Ribbon Tab) >> Data Tools >> Remove Duplicates
When the Remove Duplicates dialog box pops up, make sure that all columns of this table are selected, and then hit OK.
I hope this helps you
Regards