Sorting lots of data
 

We are trying to sort through a csv file that we converted to an excel
spreadsheet. the spreadsheet has over 40,000 entries which include mailing
addresses that are in some cases duplicated. is there anyway to sort/filter
the info to locate the duplicates and then remove them?? any help would be
greatly appreciated. thank you for your responses.

Hi
use 'Data - Advanced Filters' and check 'unique entries' or use the
following addin for this:
http://www.rondebruin.nl/easyfilter.htm

--
Regards
Frank Kabel
Frankfurt, Germany

miss lynar wrote:
We are trying to sort through a csv file that we converted to an excel
spreadsheet. the spreadsheet has over 40,000 entries which include
mailing addresses that are in some cases duplicated. is there anyway
to sort/filter the info to locate the duplicates and then remove
them?? any help would be greatly appreciated. thank you for your
responses.