Delete Duplicate Rows ??

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
 
C

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to select and delete levels of a document 2
Finding Duplicate Rows & Highlighting them 6
Macros to delete duplicate entry 1
Auto duplicate rows 0
Macro to delte Duplicate rows across multiple sheets 0
Help please with cut paste and formulas 4
Conditional Format Formula for finding duplicates in a row 1
Delete duplicate rows without deleting entire row 1

Top