View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Barrie Sean Barrie is offline
external usenet poster
 
Posts: 1
Default Trying to Find The Proper function

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