Excel help (again)?

Question

Hi i want to know the formula that looks through a list of data say this:


Name Score

Bob 65

Peter 32

Vic 87

Sally 99

James 100

Judy 34


And I want the formula to look down the list of scores and display the persons name with the highest score. In this case it would be james.

What is thre forumla. I know you can do it but i have forgotten.
Please could you include an Example

Thanks

Hearmenowinfo

The names and scores are in different columns!

Answer 1

Read the help file...

=MAX(A2:A6) --> returns the greatest value in columns a2 to a6.

you would need to put the name and score in two different columns.

Answer 2

NOTE: SEE THE SCREENSHOT TO SEE THE EXACT FORMULAE USED OR CONTACT ME HERE FOR A COPY OF THE *.xls FILE.


Hi, I have taken the liberty of using your data and creating a spreadsheet which does this for you.

THIS METHOD DOES __NOT__ BREAK IF THERE IS MORE THAN ONE PERSON AT THE NUMBER ONE POSITION.

Basically, what it does is use the RANK() function to put it in order.

If two scores are equal [eg, 100, 100, 99, 98, 97, 96], then the RANK(descending) function will return the ranks as 1,1,3,4,5,6.

To overcome this, the next column counts whether the rank has already occurred, then it adds a small fraction to the original rank.

If the RANK(ascending) function is then applied to the adjusted ranks, this gives you the correct order.


VLOOKUP() is then used to arrange the results into another table.


http://i12.tinypic.com/6gce9i1.jpg

Answer 3

Funny how nobody seems to be reading what you actually want to do. Anyway, here's the answer:

For your 6 person list, put your persons name in column B (starting at cell B1).
Then put their corresponding score in column A.
Note this is reverse from how you have it listed. Score goes first, then the name.

=VLOOKUP(MAX(A1:A6) , A1:B6 , 2 , 0)

You'll need to change the formula to match the length of your list. Note also that you won't get a valid answer if there are two or more maximum numbers since it can only return one name.

Answer 4

If you want to find the person with the highest score without sorting every time, or moving your columns, you can use this:

=INDEX(A2:A7, MATCH(MAX(B2:B7), B2:B7,0))

In this example, names are in A2:A7, scores in B2:B7

Match finds the position of the highest score in the range B2:B7 (the 100 is at the 5th cell), and Index shows the name in the same position in A2:A7 (James).

If you need more info, add more details or e-mail.
Good luck.
.

Answer 5

With names in one column (let's say column a) and scores in another (let's say column b), click on any cell with data in it & click on Data at the top.

Pick Sort and you can tell it what to sort by - in this case choose to sort by column b.

Choose to sort by descending numbers, and both columns will sort accordingly with the name and score of the highest scorer at the top.

(You can use VLOOKUP function if you wish, but the way I've given you is the simplest by far)

Answer 6

make sure they are in seperate colums.e.g. names in A and numbers in B

depending on the level of excel your using you can click on the cell with the first number and click the sort descending button in the standard toolbar. the highest score with the corresponding name will go to the top

if for somereason you can't do that, you can access sort descending from the data menu

Answer 7

i assume the information is in columns - ie one column for telephone variety, yet another for call, or in spite of. opt for each and every of the columns interior the information all the way down to the backside row. (If there is in basic terms one coumn, being for the telephone numbers, you could desire to create a 2d that is composed of dummy documents - you ought to in basic terms use numbers). Now take the chosen columns and rows, and use the pivot table function in document menu. click "next" on all wizard products. you will desire to finally end up with a sparkling table that exhibits the "count variety" of all telephone numbers. If the count variety is >a million, then you've duplicated the get entry to. Double click on the telephone variety and a sparkling sheet will open exhibiting the source. This sounds greater complicated than this is (it took me longer to form this than it does to do it). playstation maximum chilly calls are a waste of time besides!

Answer 8

i do not know the formula, but what i always do is highlight the colum with the scores and click on data (at the top) select filter, then select auto filter. There should be a drop down on the selected colum now. In the drop down box select ascending order. This will put the scores in order from highest to lowest with the names.

Answer 9

Press f1 in excel to get help. Type 'find' in the search window.
select 'look up values in a list'. This is the third item on my computer.
Select 'look up values in a range that isn't sorted'
This will explain it much better than I can.

Answer 10

You can put the person's name and score in two different columns, and sort the entire spreadsheet by score- that'll move the top score (and name) to either the top or the bottom, depending on how you sort.