using vlookup to delete duplicate data

C

carolj

Can I use vlookup to find acct#'s on a second worksheet and have it delete
the rows of the acct#'s on the 2nd wksht that are returned?
Thanks
 
S

Sheeloo

It appears that you want to delete from Sheet 2 those a/c numbers which are
on Sheet 1.

You can use VLOOKUP on Sheet 2 to mark those records, then you can filter on
NOT EQUAL To #N/A and delete those rows...
 
S

Sean Timmons

Specifically using a VLOOKUP will not cause any rows to delete. But, you can
use a couple methods to resolve your issue.

You can create some VB script to delete matching values.

You can use the VLOOKUP to show matching values, then delete entire row
based on this value.
 
C

carolj

Thank you for posting so quickly! Since my VB script is very rusty, I think
this is the way to go. I'll let you know how it works out.
 
C

carolj

Thanks for your quick response. My VB is very rusty, so I'm going to try the
vlookup & then filter & delete.
 

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

Top