View Single Post
  #2   Report Post  
Old October 7th 08, 04:44 PM posted to microsoft.public.excel.worksheet.functions
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2008
Posts: 364
Default 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