Duplicate cells

[Radiorick]

I have a large spreadsheet consisting of about 16,000 rows and 8 columns.
The first columns are longitude and latitude coordinates. Is there a way to
sort and display the rows where both the values in columns A and B are the
same? I have sorted on A then B but sometimes places have exactly the same
longitude but very different latitudes. I'm just trying to eliminate the
necessity of going through all 16000 entries to eliminate duplicates.

Thanks,

Rick Morrison
(e-mail address removed)

 

[Earl Kiosterud]

Rick,

Chip Pearson is the dupe guru. There's some stuff at his site on
duplicates. www.cpearson.com.