DMax Criteria problem
DMax Criteria problem
(OP)
Part# QTY Max
A 10 10
A 8 10
B 12 12
C 6 50
C 8 50
C 9 50
C 50 50
D 25 25
D 15 25
E 10 10
E 6 10
E 3 10
Do you know how to get the DMax function to calculate the above Max column of data? I have Part# and Qty, but I need the worksheet to calculate Max. The tricky part is that the part number list is very long, and it changes when I refresh the imported list.
A 10 10
A 8 10
B 12 12
C 6 50
C 8 50
C 9 50
C 50 50
D 25 25
D 15 25
E 10 10
E 6 10
E 3 10
Do you know how to get the DMax function to calculate the above Max column of data? I have Part# and Qty, but I need the worksheet to calculate Max. The tricky part is that the part number list is very long, and it changes when I refresh the imported list.





RE: DMax Criteria problem
=MAX($B$2:$B$13*($A$2:$A$13=A2))
and enter it as an array formula (press Ctrl-Enter instead of Enter after you have typed the formula. The formula will display as {=MAX($B$2:$B$13*($A$2:$A$13=A2))}. Array formulas tend to get slow in the case of large databases, however
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: DMax Criteria problem
Max of Qty
Part Total
A 10
B 12
C 50
D 25
E 10
Grand Total 50
on a separate sheet.