Help removing unique rows, and then one of a duplicate...

Hi guys...First post, and I'm struggling.

Basically, I have a spreadsheet. Some entries are unique, some are duplicated.

Simply put, I'm interested only in the rows that are duplicated, and only of them. Does that makes sense?

One major problem I'm having is that the criteria values aren't numerical, but text.

Can anyone help?

Cheers in advance.

=countif(column,<cell>)>0

copied the length of a column will return TRUE for any duplicates - this is good for one column.
This can be expanded with an array formula, but probably quicker and more straightforward would be to concatenate each row with =A1&B1&C1 type statements and run the same countif formula against this concatenation column.

If you want to exclude the non-dupes altogether, select the data, data->filter->advanced filter-> unique only ... then delete whatever you find, then remove the filter - you will get the number of dupes -1 of each (i.e. the first instance was treated as unique and the second as a dupe)

HTH

Awesome, cheers guys!