Yes Remove means Remove . not replace them with blanks
Yes Remove means Remove . not replace them with blanks
Code:Sub snb() sn = Application.Transpose(Filter([transpose(if(countif(B$1:B$3,A1:A12)=0,A1:A12))], False, False)) cells(1,3).resize(ubound(sn)+1)=sn End Sub
Last edited by snb; 11-25-2012 at 03:17 AM.
Bookmarks