|
|
#2
04-03-2019, 04:47 PM
|
||||
|
||||
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. 
|
|
|
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 |
Windows 10 
Office 2016
Threaded Mode