Obviously these tasks do different things! But I am using them to find out if I have duplicates :)
In excel I have a column which is a concatenation of all of the other columns. (The formula is copied down across the entire dataset)
If I select this column and get it to 'conditionally highlight duplicates' hardly anything is highlighted i.e. it cannot identify them as duplicates.
but if I use the 'remove duplicates' option, it finds all of them without problem
What is causing this behaviour and how can I prevent it?
There are about 40,000 rows and 51 columns that include strings, dates, etc
concat string length is about 1000 characters,
example snippets from concat string= 01102991666920130No0EUR0DEFAULTDEFAULT11 another example= 107219No818.517149URA2001686920140Yes0GBP