Max only if the last month is hte highest
perfect - thanks
"Joe User" wrote:
"Jim" wrote:
When referencing a row of data (say, A:K),
[....]
What I would like is a formula that will return
the max number only if the max number is in
column K. If the max number is not in K,
I would like a blank field.
One way:
=if(max(A1:K1)=K1, K1, "")
----- original message -----
"Jim" wrote:
Hello,
When referencing a row of data (say, A:K), I know I can =MAX for the highest
number on this row. What I would like is a formula that will return the max
number only if the max number is in column K. If the max number is not in K,
I would like a blank field.
Can someone help me with this?
Thanks in advance.
Jim
|