[This topic is migrated from our old forums. The original author name has been removed]
I'd like to be able to select several cells, right-click and have a Highlight Duplicates option.
For each row in the selection, this would highlight any cells where all the selected columns were duplicated.
At the moment I have to use GROUP BY and HAVING COUNT(*)>1 statements, which are a pain to geerate when you want to do a quick check, particularly if you want to peruse more columns than are in the GROUP BY clause.
over 10 years ago
[This reply is migrated from our old forums.]
Re: Duplicate data highlighting
I will open a new ticket for your suggestion.