View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg
 
Posts: n/a
Default Comparing two tables

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.