Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pulling just unique records
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pulling just unique records
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pulling just unique records
Try trimming first
-- 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
pulling just unique records
Well, I still need some hand holding. I know nothing of this formulaic syntax.
"Don Guillett" wrote: Try trimming first -- 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unique Values, not Unique Records | Excel Discussion (Misc queries) | |||
Filer for unique records and return all column data for unique rec | Excel Discussion (Misc queries) | |||
Non unique records only | Excel Programming | |||
unique filter results in some non-unique records. | Excel Discussion (Misc queries) | |||
Unique records | Excel Discussion (Misc queries) |