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
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
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
=MAX(IF($A$1:$A$25=C1,$B$1:$B$25))
as an array formula.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks Bob.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote
