Thursday, April 11, 2013

yogi_Combine Two Tables Merge And Sort To Have Multiple Columns For Unique Entities

                                          Google Spreadsheet   Post  #1112
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Apr 11, 2013
user Henrique Vilela :(!category-topic/docs/spreadsheets/xHyTjuakbkU)
Join two unique results

I'm trying to generate an result that is the unique results of a combination of two ranges, something like:

=unique(A1:A joinedwitth C1:C))

Any ideas?


As you can see I need to unique join the first two columns "A" to generate the third one.
So: UNIQUE(A,C,D,F + A,B,D,E) = A,B,C,D,E,F
following is my convoluted solution to the problem