One way...Use Advanced Filter to filter unique records in-place.
Mark these rows by filling down e.g. "X" next to the data.
Now Auto-filter the "X" column for (blanks) to show duplicates.

On 15 Jun, 00:30, TBA wrote:
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.