Thread
:
pulling just unique records
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
pulling just unique records
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"childofthe1980s" wrote in
message ...
Hello:
I am using Excel 2003, and I have three columns of data. Some of the
records of each of the three columns (a) have spaces between them and (b)
have duplicates.
Is there a way to pull out the spaces (i.e. the blank records) and
eliminate
the duplicate records?
In an attempt to filter out the duplicates, I went to Data...Advanced Sort
and checked the box "Unique records only". But, that was not correct.
Some
duplicates and at least one blank record remained.
Any help on this would be thoroughly appreciated. Thanks.
childofthe1980s
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett