Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete duplicate data | New Users to Excel | |||
delete duplicate data | New Users to Excel | |||
Delete row where there is duplicate data in Column E | New Users to Excel | |||
DELETE DUPLICATE DATA IN A SHEET AUTOMATICALLY | Excel Discussion (Misc queries) | |||
How do I delete both sets of duplicate data? | Excel Discussion (Misc queries) |