Friday, May 10, 2013

yogi_From A Column Of Authors Prepare A Table Of Rank Author Articles Written


                                          Google Spreadsheet   Post  #1186
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 10, 2013
user SouthwestJeff (http://productforums.google.com/forum/?zx=gt4fhhtub7z3#!category-topic/docs/spreadsheets/AsbzzNFWc3s)
Top X instances of text value in range, ranked
Hello.  I'm looking for a way to count the instances of a (full cell) text value in a column, and then display the top X most frequent.  For example, from source data:

                  A
1          Written By
2          Joe Smith
3          Jane Smith
4          Jerry Smith
5          Joe Smith
6          Jane Smith
7          Joe Smith

I'd like to return a table that looks like this:
Rank                    Author                    Articles Written
1                          Joe Smith                 3
2                          Jane Smith               2
3                          Jerry Smith               1

I also need to control the number of ranks displayed (i.e. Top 10, Top 25, etc)

Thanks for any help you can provide!

Jeff
----------------------------------------------------------------------------------------------------------------
following is a solution to the first part of Jeff's question