View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Zhi Sheng Zhi Sheng is offline
external usenet poster
 
Posts: 13
Default How to find what number in Column A is not included in Column B?

example:
A B
1 1
2 3
3 4
4 6
5 7
8
Here "2" and "5" are in A but not in B. Is there an easy way to highlight
numbers like this for two long lists of data?

Thank you
--
====================
ask and you shall be answered