Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
What function should i use for standings.
I have two tables on my spreedsheet, 1 shows the rosters and points the team generated and the second looks like this: Place Team Points 1 John Smith 60 2 Jane Smith 50 3 Jeff Smith 50 etc etc. i have the totals from table 1 linked to the 2nd table using the "Large" function. im trying to make table 2 100% dependable from the numbers from table 1. My questions for you guys is how do i link the team name to the teams total points i.e. if Jane smith gains 15 points to take the lead the table will look like this on my speedsheet Place Team Points 1 John Smith 65 2 Jane Smith 60 3 Jeff Smith 50 i need to know what function to use so that table looks like this automatically Place Team Points 1 Jane Smith 65 2 John Smith 60 3 Jeff Smith 50 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
PROPER FUNCTION | Excel Worksheet Functions | |||
Help w/ the PROPER function | Excel Worksheet Functions | |||
PROPER function | Excel Worksheet Functions | |||
How do I use the PROPER function? | Excel Worksheet Functions | |||
How do I use the PROPER function? | Excel Discussion (Misc queries) |