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   Sep 02, 2013
user rajvivek (!mydiscussions/docs/9BbLm3KKiMY)
How do you list unique values of a list and count occurrences of each through a SINGLE formula?

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.