Thread: How to find the largest product of an array of values?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default How to find the largest product of an array of values?
Use an array formula in column A such as:
{=MAX($B$1:$F$1*B2:F2)} using Ctrl-Shift-Enter to enter the formula.
Don't add the braces. They will be automatically entered when you use
Ctrl-Shift-Enter.

- John

Reply With QuoteReply With Quote