Thread: Max Lookup formula
View Single Post
  #5   Report Post  
sam
 
Posts: n/a
Default
Thank you. Gotto love that SUMPRODUCT.

RagDyer wrote:
Try this in H1:

=SUMPRODUCT(MAX(($A$1:$A$10=G1)*($B$1:$B$10)))

And copy down.
Reply With QuoteReply With Quote