Thread: Do Until Loop?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
carg1[_11_] carg1[_11_] is offline
external usenet poster
  
Posts: 1
Default Do Until Loop?

Technically, it'd be just the same to fill a blank column with a vlookup
formula to compare the names between the two lists, combined with an if
to mark it as "DNC", then autofilter for all the ones named DNC and
delete those. It'd be something like:

=If(IsError(vlookup(A2,'[SheetWithDNCList]Sheet1'!$A$2:$B:$100,1,0)),"","DNC")


--
carg1
------------------------------------------------------------------------
carg1's Profile: http://www.excelforum.com/member.php...o&userid=15271
View this thread: http://www.excelforum.com/showthread...hreadid=391331

Reply With QuoteReply With Quote