Thursday, February 6, 2014

yogi_Pull From Multi-Column Dataset Unique Values Array And The Corresponding Number Of Instances Of Each Unique Value

                                         Google Spreadsheet   Post  #1520
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-06-2014
post by brooke mahnken via comment in my following blog post
yogi_Compute Unique Values Array From Multi-Column Dataset
http://yogi--anand-consulting.blogspot.com/2011/01/compute-unique-values-array-from-multi.html

Yogi- your comments around the web are very helpful!  The above formula worked perfect for me.  But do you know a away I could also count the number of occurrences of each unique item and display that in the next column?  Thanks!
---------------------------------------------------------------------------------------------------------------------------------------------
Some how I don't have the spreadsheet associated with the earlier blog post anymore ... so I have created this new blog post illustration: