Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Morning folks: I am trying to do something very simple but I just can't seem
to get it to work the way I want! I have been searching for an answer for 2 days now!!! On my STATS page I have a list of basketball players down a column (taken from TEAM LIST page) and the next columns have their POINTS, REBOUNDS, ASSISTS, etc. (taken from GAMES DATA page) At the bottom, I want to see who has the most points: '=MAX(B3:B30)' and I would like to show that players name next to the number returned from MAX. The same for '=MIN(B3:B30)' I think my problem is that player #1 may have a higher number than Player#23 and my calculation returns 'N/A', am I right thinking this? Am I getting caught on some restrictions I don't know about? Thanks for all your help! Regards; Duane in Nova Scotia John 4 6 2 Sean 12 2 1 Todd 0 2 1 Andy 6 1 0 Brad 23 4 8 Vern 2 0 0 Mark 8 4 2 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using vlookup in a table that is not in ascending order | Excel Discussion (Misc queries) | |||
Why must the table for Vlookup be sorted in ascending order? | New Users to Excel | |||
How do I # my rows in ascending order. | Excel Worksheet Functions | |||
Digits in ascending order ? | Excel Worksheet Functions | |||
Is there a VLOOKUP substitute when data is not in ascending order | Excel Worksheet Functions |