I am trying to find a way to return the max value from Value1 and Value2 along with the relevant item from column 1.
I can make this work with just max value as shown on cell A7.
A8 and A11 work in varying ways, but these are only looking at single columns, surely I’m missing something simple here?
I can make this work with just max value as shown on cell A7.
A8 and A11 work in varying ways, but these are only looking at single columns, surely I’m missing something simple here?