S SIVAPRASAD's yak pad சி.சிவ பிரசாத்

Sunday, March 25, 2007

Excel Deleting Duplicate rows?

If your data set has multiple columns consider the following...

Let's assume that cells A1:B6 contain...

{"Field1","Field2"

;"Cat","Mouse"

;"Dog","Bone"

;"Cat","Mouse"

;"Mouse","Cheese"

;"Mouse","Cheese"}

1. Enter the formula, =A2 into cell C2 and

Copy down. Note: It's a good idea to delimit

variable length values with a character (comma in

this case) not found in your data set.

2. Enter the formula, =COUNTIF(C2:$C$6,C2), into

cell D2 and Copy down.

3. AutoFilter column D:D for value(s) that "does

not equal" 1

4. Delete all visible data rows.





powered by performancing firefox

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]



<< Home