Monday, January 31, 2011

yogi_Compute Unique Values Array From Multi-Column Dataset

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com




Range A2:D4 ... Dataset

F2: =ArrayFormula(unique(transpose(split(concatenate(A2:D4&" ")," "))))