Select data on max value

[Closed]
Report
Posts
6
Registration date
Sunday October 31, 2010
Status
Member
Last seen
March 28, 2011
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Hello,



i have a simple question but i coudnt solve it!
i have a query by named query1 that have a column ((testname)) by various numbers between 1 and 12.
i want to design a select query to select datas where data=max(testname)

note : this clolumn (testname) is an expression column

thanks alot

1 reply

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
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)).
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month