filter data

[mimoncayo]

I have an excel sheet with 30.000 + rows/entries, 6 columns, I want to
eliminate double entries, I have sorted the document and i have rows
that repeat but don't want to do it manually.
Thank you,

 

[drabbacs]

If you are familiar with pivottables you could eliminate
them that way.

-----Original Message-----

I have an excel sheet with 30.000 + rows/entries, 6 columns, I want to
eliminate double entries, I have sorted the document and i have rows
that repeat but don't want to do it manually.
Thank you,


------------------------------------------------
[/url]
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step

guide to creating financial statements

 

[Maxwell]

Do you want to eliminate duplicates in rows or columns?
If columns is it in a particular column or all columns?
How about rows?

-----Original Message-----

I have an excel sheet with 30.000 + rows/entries, 6 columns, I want to
eliminate double entries, I have sorted the document and i have rows
that repeat but don't want to do it manually.
Thank you,


------------------------------------------------
[/url]
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step

guide to creating financial statements

 

[Debra Dalgleish]

You can use an Advanced Filter to extract the unique values from the
table. There are instructions here:

http://www.contextures.com/xladvfilter01.html#FilterUR

Or, mark the duplicates, and delete those rows. There are instructions
on Chip Pearson's web site:

http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates

 

[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.

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