pulling just unique records

C

childofthe1980s

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
 
D

Don Guillett

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
 
C

childofthe1980s

Well, I still need some hand holding. I know nothing of this formulaic syntax.
 
G

Gord Dibben

You will find TRIM function in help.

Examples of usage provided


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete duplicates based on time 1
Deleting near-duplicate records that differ only by blanks 3
how do i show non-unique records (duplicates) using advanced filte 3
"order by" and removing newer records 3
Duplicate records 1
Help with pseudocode translated into VBA Code 1
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
Strip out certain rows that have merged cells 2

Top