ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   using vlookup to delete duplicate data (https://www.excelbanter.com/excel-worksheet-functions/205416-using-vlookup-delete-duplicate-data.html)

carolj October 7th 08 04:38 PM

using vlookup to delete duplicate data
 
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

Sheeloo[_2_] October 7th 08 04:44 PM

using vlookup to delete duplicate data
 
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...


"carolj" wrote:

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


Sean Timmons October 7th 08 05:18 PM

using vlookup to delete duplicate data
 
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.



"carolj" wrote:

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


carolj October 7th 08 05:50 PM

using vlookup to delete duplicate data
 
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.



"Sheeloo" wrote:

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...


"carolj" wrote:

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


carolj October 7th 08 05:53 PM

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



"Sean Timmons" wrote:

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.



"carolj" wrote:

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



All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
ExcelBanter.com