sumproduct to find a maximum value ?

[oldbrewer]

I want the max value for red - suitable for excel 2000,thanks.

red	15
blue	17
red	16
red	14
blue	12
blue	13
red	15
red	14
red	13
red	12
blue	19
blue	18

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[rolfhoh]

Highest sales with
=INDEX(CustomerColumn,MATCH(SUMPRODUCT(MAX(TotalSalesColumn)*1),TotalSalesColumn,0))
give the answer "The Dandelion"
..SUMPRODUCT(MAX(TotalSalesColumn)*1),TotalSalesColumn,0) give the row number for Index to pull out the customer with highest total sale
Rolfhoh

 

[Aladin Akyurek]

Highest sales with
=INDEX(CustomerColumn,MATCH(SUMPRODUCT(MAX(TotalSalesColumn)*1),TotalSalesColumn,0))
give the answer "The Dandelion"
..SUMPRODUCT(MAX(TotalSalesColumn)*1),TotalSalesColumn,0) give the row number for Index to pull out the customer with highest total sale
Rolfhoh

Apparently, you have skipped the discussion involving SUMPRODUCT(MAX(…)) which took place in this thread.