LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PROPER FUNCTION ACE PRODUCTS Excel Worksheet Functions 5 July 12th 07 01:38 AM
Help w/ the PROPER function arneson Excel Worksheet Functions 2 August 4th 06 10:22 PM
PROPER function Danielle via OfficeKB.com Excel Worksheet Functions 2 October 14th 05 09:50 PM
How do I use the PROPER function? Lynn in Tulsa Excel Worksheet Functions 6 August 15th 05 07:36 PM
How do I use the PROPER function? kp Excel Discussion (Misc queries) 3 December 30th 04 01:44 PM


All times are GMT +1. The time now is 01:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"