Select data on max value
Closed
rahimisoft
Posts
6
Registration date
Sunday October 31, 2010
Status
Member
Last seen
March 28, 2011
-
Mar 28, 2011 at 01:58 PM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Mar 29, 2011 at 01:20 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Mar 29, 2011 at 01:20 AM
Related:
- Select data on max value
- Vba select case like - Guide
- Hbo max download pc - Download - Movies, series and TV
- Free fire max download - Download - Battle royale
- Sound max - Download - Drivers
- Max repel cheat code - Guide
1 response
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 29, 2011 at 01:20 AM
Mar 29, 2011 at 01:20 AM
if you want to a particular value from a coloumn (its on column B) with respect to maximum value (test name suppose it is in column E). you can use the function.
=INDEX(B:B,MATCH(MAX(E:E),E:E,0)).
=INDEX(B:B,MATCH(MAX(E:E),E:E,0)).
