oooooh
thank you soooo much, i checked the link but it somehow didnt do what i
wanted, now i found what was
wrong, first i had the exchange the order of the two lists and second was
the instead of =
thank you very much


"Herbert Seidenberg" schrieb im Newsbeitrag
oups.com...
Please review the link http://tinyurl.com/9gflw
Sloth highlights the numbers 3 and 5
with conditional formatting and then he erases them.
Since you want to save those numbers, just do the opposite.
Instead of
=COUNTIF(Range,Criteria)=0 use
=COUNTIF(Range,Criteria)0
Two alternate ways are listed using Advanced Filter and array formulas.
Modify them in a similar way.