B
bscarano
OK, here's my question.
I have a list of a set of values listed below:
REP Total
John 12500
Peter 16955
Rich 14986
Steve 11986
Joe 13579
Joann 12697
=INDEX(REP,MATCH(MAX(Total),Total,0)) <--Max Value(16955),Peter
=INDEX(REP,MATCH(MIN(Total),Total,0)) <--Min Value(11986),Steve
I want to, based on value, sort these on another sheet. Using the
formula above, I can get the MAX and MIN. How do I go about getting
the rest of the values sorted accordingly?
Fester.
I have a list of a set of values listed below:
REP Total
John 12500
Peter 16955
Rich 14986
Steve 11986
Joe 13579
Joann 12697
=INDEX(REP,MATCH(MAX(Total),Total,0)) <--Max Value(16955),Peter
=INDEX(REP,MATCH(MIN(Total),Total,0)) <--Min Value(11986),Steve
I want to, based on value, sort these on another sheet. Using the
formula above, I can get the MAX and MIN. How do I go about getting
the rest of the values sorted accordingly?
Fester.