Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Worksheetfunction nesting max if

Worksheetfunction nesting max if

ResolvedVersion 2007

Tue 31 May 2011, 21:36 Delegate 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:26 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips

Worksheetfunction nesting max if

Worksheetfunction nesting max if

RE: Worksheetfunction nesting max if

Excel articles

Excel tip:

New Normal Worksheet