Create 'Find' style box to display duplicated text entries

[zoso]

Hi there!

I've searched the board but am unable to find a way to display a list of all text entries that are duplicated, in the same way that the Find button shows all the cells containing a defined string.

My problem is that my sheet has about 2,000 rows in it, and I suspect there are unwanted duplicates but don't know what is duplicated, so the 'find' function is of no use!

What I'm after is a display that doesn't interfere in any way with the cells - just like the Find function i.e. I wouldn't want cells highlighting because I will have to manually 'un-highlight' them all afterwards. This will be a daily check, so I want to avoid the hassle of pasting the data to a blank sheet and the cells being highlighted there for me to check through every time.

Hope you can help!

 

[zoso]

Guys - thanks a lot for your suggestions, I'll give them a try and let you know.

 

[Shakfe]

Hello all, is there a way to sort duplicates on the basis of the data appearing on 2 columns?
I mean, if in the previous example, in column 'b' there was the brand of apples, bananas & so on and we wanted to sort out duplicates for items and their brand?
thanks for help!

 

[erik.van.geit]

Hi, Shakfe
still waiting for a solution ?
couldn't get here earlier

your question is not clear to me
is this really related to this topic ?
(must miss something)
if so please elaborate with an example

kind regards,
Erik