PDA

View Full Version : Solved: Max Values - Formula solution



mdmackillop
08-20-2008, 03:10 PM
Anyone got a formula solution (or other excluding VBA) for Max values from column B for filtered values in columm C. In "real life" I have 36K column A/B values and 1800 column C values
Regards
MD

Bob Phillips
08-20-2008, 03:26 PM
=MAX(IF($A$1:$A$25=C1,$B$1:$B$25))

as an array formula.

mdmackillop
08-20-2008, 03:55 PM
Thanks Bob.