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&" ")," "))))

2 comments:

  1. What if the values are not a single character, but a string of text (including some characters) like: "Cultivating a Culture of Growth Classroom Visits to Address the Excitement & Challenges of Teaching (Thompson, Blankenship, Andrews)"

    ReplyDelete
  2. Hi Joel:

    How about if you provide a few rows and columns of some sample data and your expected result along with needed logic or explanation ...
    and then let us take it from there.

    Make It A Great One
    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete