no duplicates

  • Thread starter Thread starter YoungAdmin AtreyuLohan
  • Start date Start date
Y

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?
 
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
 
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?
|
 
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?
Click to expand...

Gord Dibben XL2002
 
Back
Top