I am having great difficulty trying to identify duplicates on a database that
I have. The database has about 2000 entries (2000 different rows) of numeric
and non-numeric data (names and addresses etc.) organised into 30 columns.
The data also does not have any unique identifiers within it.

All i need to do is identify duplicate rows but in excel this seems very
hard to do. I can only put an advanced filter and duplicates will be deleted
by the unique records only function. I can't write a formula because the data
is non-numeric.