Delete Duplicate Rows ??

  • Thread starter Thread starter InOverMyHead
  • Start date Start date
I

InOverMyHead

Is there a function that will find duplicate entries and delete them? For
example, if B7 = B8 then delete row 7 (or 8)? Maybe a macro I could write?
Or better yet, maybe somebody has already written something I could
"borrow".

Any help would be greatly appreciated.

Bob
 
Sort the data so that all the duplicates are in subsequent rows, grouped
together,
then you can use a helper column with a formula like
(assuming your data in column A and helper column is column B) put in
B2..... =IF(A2=A1,1,0) and copy it down column B as far as you have data in
column A.......then Copy > Paste special > Values on column B and then sort
on column B
and all the 1's will be together and you can delete those rows, (ie the
duplicates)..........

Vaya con Dios,
Chuck, CABGx3
 
Back
Top