ExcelBanter - deleting duplicate rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - deleting duplicate rows (https://www.excelbanter.com/excel-discussion-misc-queries/125412-deleting-duplicate-rows.html)

Jess

deleting duplicate rows

I have a spreadsheet with over 3000 records. Is there a way to auto delete
any duplicate records? Please help! Thanks

Gary''s Student

deleting duplicate rows

See:

http://www.cpearson.com/excel/deleti...eDuplicateRows
--
Gary's Student

"Jess" wrote:

I have a spreadsheet with over 3000 records. Is there a way to auto delete
any duplicate records? Please help! Thanks

Gord Dibben

deleting duplicate rows

Jess

DataFilterAdvanced FilterUnique Records Only.

Filter in place or copy to another range.

For more on this see Debra Dalgleish's site.

http://www.contextures.on.ca/xladvfilter01.html

Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 14:59:00 -0800, Jess wrote:

I have a spreadsheet with over 3000 records. Is there a way to auto delete
any duplicate records? Please help! Thanks

Teethless mama

deleting duplicate rows

Create a Helpler column
=COUNTIF($A$2:A2,A2)=1
AutoFilter all the FALSE
Select all the filter range then go to menu select Edit Delete Rows

"Jess" wrote:

I have a spreadsheet with over 3000 records. Is there a way to auto delete
any duplicate records? Please help! Thanks

All times are GMT +1. The time now is 04:53 AM.