I need to find the max value out of one colume and display the value of the
colume to the left of the max value.
--
Brian

something like:

=index(A1:A99,match(max(b1:b99),b1:b99,0))

Brian Cornejo wrote:

I need to find the max value out of one colume and display the value of the
colume to the left of the max value.
--
Brian

--

Dave Peterson

Since it can be excluded that there can be multiple instances of the max
value and therefore multiple associated values, try:

http://tinyurl.com/64mz3


Brian Cornejo wrote:
I need to find the max value out of one colume and display the value of the
colume to the left of the max value.