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     www.energyefficientbuild.com.    Apr 11, 2013
user Henrique Vilela :(http://productforums.google.com/forum/?zx=kt0soilg3ufa#!category-topic/docs/spreadsheets/xHyTjuakbkU)
Join two unique results
Hi,

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

No comments:

Post a Comment