sumproduct to find a maximum value ?

[oldbrewer]

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

[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl22, width: 64"]red[/TD]
[TD="class: xl22, width: 64"]15[/TD]
[/TR]
[TR]
[TD="class: xl22"]blue[/TD]
[TD="class: xl22"]17[/TD]
[/TR]
[TR]
[TD="class: xl22"]red[/TD]
[TD="class: xl22"]16[/TD]
[/TR]
[TR]
[TD="class: xl22"]red[/TD]
[TD="class: xl22"]14[/TD]
[/TR]
[TR]
[TD="class: xl22"]blue[/TD]
[TD="class: xl22"]12[/TD]
[/TR]
[TR]
[TD="class: xl22"]blue[/TD]
[TD="class: xl22"]13[/TD]
[/TR]
[TR]
[TD="class: xl22"]red[/TD]
[TD="class: xl22"]15[/TD]
[/TR]
[TR]
[TD="class: xl22"]red[/TD]
[TD="class: xl22"]14[/TD]
[/TR]
[TR]
[TD="class: xl22"]red[/TD]
[TD="class: xl22"]13[/TD]
[/TR]
[TR]
[TD="class: xl22"]red[/TD]
[TD="class: xl22"]12[/TD]
[/TR]
[TR]
[TD="class: xl22"]blue[/TD]
[TD="class: xl22"]19[/TD]
[/TR]
[TR]
[TD="class: xl22"]blue[/TD]
[TD="class: xl22"]18[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.