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
rlmorrison@earthlink.net
Earl Kiosterud - 19 Sep 2006 21:31 GMT
Rick,
Chip Pearson is the dupe guru. There's some stuff at his site on
duplicates. www.cpearson.com.

Signature
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
>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
[quoted text clipped - 7 lines]
> Rick Morrison
> rlmorrison@earthlink.net