Hi. This midterm elections I would like to set up a poll quick count system. I need your help in providing a macro that when a button is activated, the rank, column c, is sorted from number 1 (highest number of votes) up to the last rank, per office. Sample sheet attached, thank you.


In the actual workbook, there are several data sheets and another sheet consolidating all the data sheets.

Attached Files

Count.xlsx (28.0 KB, 13 views)

Rather than sort the original table (since this messes up your rank formulae) make a pivot table and refresh it when the data gets updated.
See pivot table at cell Q3 in the attached.
Note, that to keep the 2 districts of SANGGUNIANG PANLALAWIGAN separate I edited the cells A76:A89 and A91:A98 to reflect this.

Attached Files

msofficeforums42132Count.xlsx (37.0 KB, 11 views)

Hi, p45cal. I guess I have to let pivot table do the work of sorting the data according to the rank or total number of votes. Thank you.