Min Max Question
On Nov 2, 2:29*pm, Don Guillett wrote:
On Nov 2, 11:15*am, "joeu2004" wrote:
"carl" wrote:
I am looking for a formula that will produce this table:
Stock Low High
AA 1 4
BB 1 3
Assuming you enter the names of the stocks starting in A2 of a summary
worksheet and your data is in a worksheet called Data starting in A2, enter
the following array formulas[*] starting in B2 and C2 of the summary
worksheet and copy down:
B2: *=MIN(IF(Data!$A$2:$A$5000=A2,Data!$B$2:$B$5000))
C2: *=MAX(IF(Data!$A$2:$A$5000=A2,Data!$B$2:$B$5000))
Note: *In XL2007 and later, you might be able to use the unbounded ranges
Data!$A:$A and Data!$B:$B. *I'm not sure.
[*] Enter an array formula by pressing ctrl+shift+Enter instead of Enter.
|