#1
|
||||
|
||||
How to sort poll result ranked in ascending order
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. Last edited by Marcia; 04-03-2019 at 07:18 AM. Reason: additional information |
#2
|
||||
|
||||
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. |
#3
|
||||
|
||||
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.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sort numbers in Ascending order | btserver | Excel | 5 | 03-16-2019 07:54 AM |
Can't figure out sort order in OneNote | kcirbostosf | OneNote | 1 | 05-18-2018 10:25 AM |
Degree symbol not in expected sort order. | slaycock | Word | 0 | 01-22-2018 09:05 AM |
What is the Word sort order for text? | Jennifer Murphy | Word | 2 | 01-27-2017 07:18 PM |
VBA Sort Custom Order | tandchas | Excel Programming | 1 | 04-15-2016 05:38 PM |