filter data

  • Thread starter Thread starter mimoncayo
  • Start date Start date
M

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,
 
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,


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step
Click to expand...
guide to creating financial statements
 
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,


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step
Click to expand...
guide to creating financial statements
 
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
 
Back
Top