Similar to the above:

I would also like to Know the max value of the values in column B in
rows for which the value in column A of the row is 5.3.

I would like to do similarly with calculating the 90th Percentile

And if possible a formula for use in a line graph that would only plot
the values in column B, that had a corresponding value of 5.3 in column
A

Any ideas?


--
coa01gsb
------------------------------------------------------------------------
coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214
View this thread: http://www.excelforum.com/showthread...hreadid=520503