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   Feb-06-2014
post by brooke mahnken via comment in my following blog post
yogi_Compute Unique Values Array From Multi-Column Dataset

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: