View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FrozenRope FrozenRope is offline
external usenet poster
 
Posts: 6
Default How do I create a list of unique values from 2 columns of data

I have 2 columns of data. Column A has 50,000 records and Column B has 4,000
records (many of which are in Column A).

I need to generate Column C which should be all of the values from Column A
that are not also in Column B. The net yield for Column C should be roughly
46,000 records.

How can I go about solving this problem?

Many thanks!!!!