In searching a column for duplicate dates (e.g. 9/10/2019, 9/20/2019, 9/21/2019 etc), when I use the Remove Duplicates tool, it finds the duplicates and tells me the unique values, but when I click OK, what remains is the first date only listed 10 times, rather than the 10 unique dates. The remove duplicates function works fine with a list of integers, but not with my dates. The column of dates were derived from extracting the date from a timestamp in the adjacent column to the left using =INT. I appreciate any advice that might be offered.
For us to be able to help you better, please let us know if you're using the standard Excel Remove Duplicates tool or our Duplicate Remover add-in. Also, please send us a small sample workbook with your duplicate dates, the result you'd like to get, and what you have as the result now to firstname.lastname@example.org. Our technical specialist will look into your task and try to help. Thank you.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!