Monday, September 2, 2013

yogi_From All The Names in A Column Extract List Of Unique Names And The Corresponding Count Of Those names In The Column

                                          Google Spreadsheet   Post  #1354
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep 02, 2013
user rajvivek (http://productforums.google.com/forum/?zx=fu1hfkvr8c2v#!mydiscussions/docs/9BbLm3KKiMY)
How do you list unique values of a list and count occurrences of each through a SINGLE formula?
Hi!

I have a set of names in column A3:A500, and many of them are duplicates... Is it possible to have a SINGLE formula (preferably QUERY one) that could both enlist unique names in Column B & no. of their occurrence in Column C without having to bother to add another formula or column in an already data-heavy spreadsheet?

I tried to use Pivot in Query but only got errors.

Thanks!
----------------------------------------------------------------------------------------------------------------------------