Thread: Formula help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Formula help

Take a look he

http://www.cpearson.com/excel/duplic...#InOneNotOther

"schreibdave" wrote:

Hi

I need help creating a formula that would do the following: I have two
columns of numbers - they are customer #s. Some of the numbers are in both
columns, others are in one column. How would I set up a formula to identify
which numbers are in one coumns but not in the other? Thanks a lot.