EXEL HOW TO FIND MAX

Solved/Closed
LJS - Feb 4, 2010 at 03:59 PM
 LJS - Feb 5, 2010 at 04:06 AM
Hello, On exel i know its possible to get the computer to find the MAX value from a set of numbers, but in my case i want it to find the max value but instead of showing the figure in the cell, but to show the corresponding column heading like 'Cakes' for example.

PLEASE HELP THIS IS FOR COURSEWORK.

5 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Feb 4, 2010 at 04:40 PM
Could you give some sort of sample lines to know exactly what you seek
0
Say i have to following data:

Ages
16-20 21-30 30-40

Walking 23 12 21
Running 32 23 25
Cycling 43 26 28
Swimming 43 21 22


And i use the formula =MAX() of the numbers for walking, obviously the biggest number is 23, but i dont want this in the cell i want 'Walking'.


Thank-you
0
No sorry i got that wrong i want '16-20' not 'Walking'

Sorry.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Feb 4, 2010 at 06:12 PM
=INDIRECT(ADDRESS(1,MATCH(MAX(A2:D2),A2:D2,0)))
0

Didn't find the answer you are looking for?

Ask a question
Thank-You so much worked perfectly, if i have trouble in the future please help me again.
0