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)