Array Formula - Offset Result Problem
Your right, forgot about duplicates, thanks for the correction
Mike
"JMB" wrote:
you would get an incorrect result if the data we
2 red
5 red
5 blue
4 green
where another color happens to have a number that equals blues max and
appears before blue in the list.
"Mike H" wrote:
Vlad,
It's still an array
=INDEX($B$2:$B$115,MATCH(MAX(($E$2:$E$115)*($H$2:$ H$115="Blue")),$E$2:$E$115,FALSE),1)
Mike
"Vlad" wrote:
The following Array formula retulrns the maximum value in column E
where the value in Column H is Blue
{=MAX(($E$2:$E$115)*($H$2:$H$115="Blue"))}
How would I return the text in Column B for which is on the same line
as the maximum value in column E where the value in Column H is Blue
I'm using Excel 2003
TIA
A
|