Hello!
Lets say I have a sheet which contains data in columns A-W and from cell 1-3000
I want to create a filter so all duplicates in column A are shown. To do this I:
Mark all data in column A.
Click the 'Conditional Formatting' button
Choose 'Highlight cells rules' and 'Duplicate Values'.
Then I filter on colour and only the duplicates values will be shown.
The problem with this s when I do this on a large set of data excel have problem to do this and just shut down.
Is there any way to let excel warn me that this will take long time to execute before it start the procedure?
Thanks!
Bookmarks