Remove duplicate rows
-
JIGYANSHA1985
- StarLounger
- Posts: 77
- Joined: 15 Jan 2011, 02:32
Remove duplicate rows
How to remove duplicate row having same numeric data at A3 column. For ex. at sheet1 ACNO is a field name which contains 11 digit numeric data. If any duplicate ACNO found then cut those records (total row) and paste at sheet5.
Last edited by HansV on 02 Feb 2011, 06:49, edited 1 time in total.
Reason: to provide meaningful subject - just "excel" is not descriptive
Reason: to provide meaningful subject - just "excel" is not descriptive
-
Jan Karel Pieterse
- Microsoft MVP
- Posts: 656
- Joined: 24 Jan 2010, 17:51
- Status: Microsoft MVP
- Location: Weert, The Netherlands
Re: excel
There is a manual way.
1. Enter this formula into an empty column:
=COUNTIF($A3:$A$1000,A3)
(notice the dollar signs!)
2. Filter your sheet on that new column, filter on greater than 1
3. Now you should be able to copy the filtered rows to the other sheet
4. hit the del key on the filtered sheet, remove the filter and sort the sheet so the empty rows are together, ready for you to delete them.
1. Enter this formula into an empty column:
=COUNTIF($A3:$A$1000,A3)
(notice the dollar signs!)
2. Filter your sheet on that new column, filter on greater than 1
3. Now you should be able to copy the filtered rows to the other sheet
4. hit the del key on the filtered sheet, remove the filter and sort the sheet so the empty rows are together, ready for you to delete them.