ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   About this forum (https://www.excelbanter.com/about-forum/)
-   -   sorting (https://www.excelbanter.com/about-forum/198624-sorting.html)

old coach

sorting
 
number name
3 joe
6 bill
5 charles
6 doug
9 ed
Number changes as information is input at another location. Name remains the same.


Number represents a sum total of other input, or points.

As I input the numbers in another location, the sum is put here. I want to sort the information in decending order by number linking the results to a report. I do not want to do a manual sort.

results-- leading scorer ed 9
bill 6
doug 6
charles 5, etc. until the list is finished. it may include 20 names or 15.

If I add 5 poits to bill (11) then it would resort the list automatically.


All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com