totalnatal
New Member
- Joined
- Jun 9, 2010
- Messages
- 33
Hello,
Say I have a MAX function which selects the MAX between 10 variables which are calculated in VBA code.
Ex:
In Year 1, the max function looks at those 10 variables, selects the one with the highest value.
I want the code to then exclude that variable for future MAX calculations as in in Year 2 the MAX function would select the maximum value between the 9 variables left and so on.
How would go about doing this?
Thank you
Say I have a MAX function which selects the MAX between 10 variables which are calculated in VBA code.
Ex:
In Year 1, the max function looks at those 10 variables, selects the one with the highest value.
I want the code to then exclude that variable for future MAX calculations as in in Year 2 the MAX function would select the maximum value between the 9 variables left and so on.
How would go about doing this?
Thank you
