98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Worksheetfunction nesting max if
Worksheetfunction nesting max if
Resolved · Medium Priority · Version 2007
Tue 31 May 2011, 21:36Delegate Tony said...
Tony has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Access Intermediate course
Access Advanced course
Worksheetfunction nesting max if
I am try to create array formula in Excel VBA. In excel, I would use the formula
{max(if(name1=a2,name2))}
name1 and name 2 are named ranges
i am happy using worksheetfunction for max or if but do not know how to do a nested function to get max if
Wed 8 Jun 2011, 09:26Trainer Stephen said...
RE: Worksheetfunction nesting max if
Hi Tony
Thanks for the question
Could you clarify for me whether you wish to create a customised function procedure, or if you wish to use the above as the formula property of a cell object?
Thanks
Stephen
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Checking if a calculation adheres to Order of PrecedenceWhen writing formulas you must make sure that results will be calculated as you intended. |
