In column A, list the challenge participants alphabetically (they're easier to find that way). In column B, list the watch counts. Right-click at the top of the pivot table (i.e, cell D1) and select "Refresh". Then, copy the relevant rows (i.e., row 1 through however many participants there are) in columns F through L, and paste them between the "table" tags here in the forum.
Ranks are automatically calculated. Updates may be available upon request.
EDIT: Link to a Google Sheets Version (enter values in the first two columns; values should update automatically). Copy the columns E:K and put them between
Code: Select all
https://docs.google.com/spreadsheets/d/ ... sp=sharing