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 |
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 |
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 |
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 |
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:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com