Home |
Search |
Today's Posts |
#3
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 |
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) |