here you go:
list1: A10:A20
list2: B10:B20
as an arrayformula:Code:Sub tst() [A10:A20] = [if(countif(A10:A20,B10:B20)>0,"",A10:A20)] End Sub
PHP Code:{=IF(COUNTIF(A10:A20;B10:B15)>0,"",A10:A20)}
here you go:
list1: A10:A20
list2: B10:B20
as an arrayformula:Code:Sub tst() [A10:A20] = [if(countif(A10:A20,B10:B20)>0,"",A10:A20)] End Sub
PHP Code:{=IF(COUNTIF(A10:A20;B10:B15)>0,"",A10:A20)}
Last edited by snb; 10-05-2012 at 12:48 AM.
Bookmarks