Thread: formula for extracting uniques using 2 columns
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] kaisei.tamahagane@gmail.com is offline
external usenet poster
  
Posts: 3
Default formula for extracting uniques using 2 columns

wrote:
Hi Guys!

I was wondering if any one can help me on my question. How can I
extract unique numbers from column A and column B has numbers that are
also found in column A? How can I produce a column of unique numbers
coming from column A.

Sample
Column A Column B Column C
21074721867 21083028866 (unique numbers coming from A pitted against B )
21083026860 21083054862
21083028866 21083374864
21083053864 21083922860
21083054862 18180315865
21083225868
21083374864
21083451860
21083453866
21083631867
21083922860
21083923868
15483881866
18180315865
21062295866
21070845868
21082007861
21082008869
21082009867
21082011863

I really appreciate the help. Thank you in advance!

Kaisei Tamahagane

Reply With QuoteReply With Quote