EXEL HOW TO FIND MAX
Solved/Closed
Related:
- EXEL HOW TO FIND MAX
- Max revive cheat pokemon fire red - Guide
- Design a program to print the following pattern sample input: enter the number to be printed: 1 max number of time printed: 3 1 ✓ - Forum - Programming
- Mac mini m1 max release date - Guide
- Sound max - Download
- Swish max - Download
5 replies
rizvisa1
Feb 4, 2010 at 04:40 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Feb 4, 2010 at 04:40 PM
Could you give some sort of sample lines to know exactly what you seek
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
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
rizvisa1
Feb 4, 2010 at 06:12 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Feb 4, 2010 at 06:12 PM
=INDIRECT(ADDRESS(1,MATCH(MAX(A2:D2),A2:D2,0)))
Didn't find the answer you are looking for?
Ask a question