EXEL HOW TO FIND MAXSolved/Closed

Question

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.

rizvisa1 · Answer

Could you give some sort of sample lines to know exactly what you seek

LJS · Answer

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

LJS · Answer

No sorry i got that wrong i want '16-20' not 'Walking'

Sorry.

rizvisa1 · Answer

=INDIRECT(ADDRESS(1,MATCH(MAX(A2:D2),A2:D2,0)))

LJS · Answer

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

EXEL HOW TO FIND MAX

5 responses

Subscribe To Our Newsletter!