I am trying to create a spreadsheet where a ranking system can be inserted and updated.
I have one worksheet where people are ranked. mark 1, paul 2, etc and goes down like that.
The next worksheet has a list of "sections" where people would go in ranking order. However, not everyone on the ranking page will be on the sections sheet. I want to be able to put someone like Paul on the sections sheet and he will be placed in ranking order. for example i have paul 2, jim 4, suzy 7. I want the sections sheet to put them in ranking order. How can i do this? The ranking worksheet has one cell for the name and a seperate cell for the ranking order.
thanx!