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:
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:
No comments:
Post a Comment