Array Formula - Offset Result Problem
On Mar 1, 9:23*pm, 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.
Thanks for the suggestion but they don't work for me as it is quite
likely that there would be duplicate items with the same max value.
I thought something like {=MAX(($E$2:$E$115)*($H$2:$H$115=$J4)*($B$2:$B
$115))} would work but it doesn't.
Any other suggestions?
TIA
|