no duplicates

[YoungAdmin AtreyuLohan]

I have a list on a column with about 300 or so entries (text & numbers),
most of them are the same, but the are a few (about 1/3) that are not. I
want to be able (on another sheet), to scan the column and display only one
of each different entry. How would i do that?

 

[Gord Dibben]

Insert a new worksheet.
Select your data range on original sheet.
Data>Filter>Advanced Filter.
Check "Unique records only" and "copy to a new location".

Your "listrange" will be already entered. In the "copy to" click on the
Collapse Dialog button and select your new worksheet A1.

OK your way out.

You can now delete the original list.

Filtering Tutorial at Debra Dalgleish's site.......
http://www.contextures.on.ca/tiptech.html

More on Duplicates marking, preventing at Chip Pearson's site....
http://www.cpearson.com/excel/topic.htm

Scroll down to "D" section and select Duplicate topics.

Gord Dibben XL2002

 

[YoungAdmin AtreyuLohan]

Thank you, very helpful, but is there a way to automate the process with a
formula?

--

:: YoungAdmin :: AtreyuLohan ::
<Gord Dibben> wrote in message
| Insert a new worksheet.
| Select your data range on original sheet.
| Data>Filter>Advanced Filter.
| Check "Unique records only" and "copy to a new location".
|
| Your "listrange" will be already entered. In the "copy to" click on the
| Collapse Dialog button and select your new worksheet A1.
|
| OK your way out.
|
| You can now delete the original list.
|
| Filtering Tutorial at Debra Dalgleish's site.......
| http://www.contextures.on.ca/tiptech.html
|
| More on Duplicates marking, preventing at Chip Pearson's site....
| http://www.cpearson.com/excel/topic.htm
|
| Scroll down to "D" section and select Duplicate topics.
|
| Gord Dibben XL2002
|
| On Tue, 4 Nov 2003 14:11:14 -0500, "YoungAdmin AtreyuLohan"
|
| >I have a list on a column with about 300 or so entries (text & numbers),
| >most of them are the same, but the are a few (about 1/3) that are not. I
| >want to be able (on another sheet), to scan the column and display only
one
| >of each different entry. How would i do that?
|

 

[Gord Dibben]

Have you looked at Chip's Duplicates pages? May be something there to suit
your needs.

"Automate" ususally involves VBA.

Gord

Thank you, very helpful, but is there a way to automate the process with a
formula?

Gord Dibben XL2002