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

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

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

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

pulling just unique records
 

You will find TRIM function in help.

Examples of usage provided


Gord Dibben MS Excel MVP

On Wed, 19 Aug 2009 08:48:01 -0700, childofthe1980s
wrote:

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