Wednesday, March 19, 2014

yogi-Create A Sort Of LeaderTable Showing Users With Number of Posts In Descending Order

                                         Google Spreadsheet   Post  #1565
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Mar-19-2014
post by dann w (!category-topic/docs/spreadsheets/lJH_WtHTivI)
Get sum of values by username and sort
Hi everybody!  Sorry for the confusing title, but here's an explanation of what I'm trying to do.  Here's an example sheet:

In this sheet, each day has a username and how many reports they submitted that day.  Each day is range sorted so the username with the most amount of reports shows up at the top.  The list of usernames is always changing (there are tens of thousands of usernames who may or may not submit a report on a given day), so they will never line up on the same row to do an easy SUM formula.

What I need is a way to figure out what username has done the most reports on a sheet.  I know i can 'count' the number of occurrences of a username in the sheet, but that will just show how many times the username showed up and not the number of reports they submitted.  What I need is a sum of reports submitted by a username over a given period and then have that sorted by the username that submits the most reports. Hope this makes sense.  Thanks for any help that can be offered.