frankieB
New Member
Hi Guys,
New guy to the forum but not new to excel. I enjoyed searching for answers as I read some of your formulas. Really impressive.
I have a formula that I can't figure out for the life of me. Here's the logic and below is a screen shot for visual help.
=INDEX(BSN!$E:$E,MATCH(MAX(MMULT($D$3:$D$10{1})),MMULT($D$3:$D$10,{1}),0))
The Visual:
New guy to the forum but not new to excel. I enjoyed searching for answers as I read some of your formulas. Really impressive.
I have a formula that I can't figure out for the life of me. Here's the logic and below is a screen shot for visual help.
- Requires two sets of criteria (data in column A and B)
- I need to return the 'Account Type' (column C)
- The 'Account Type' I need to be returned is the one who has the maximum 'Gross' value (column D)
- I can't use the whole column, only the last row (The data will increase/decrease in quantity, so I have to update the formula manually- e.g I have to update the row count- the ... $D$10 part)
- I can't set the two criteria I need without getting an error
=INDEX(BSN!$E:$E,MATCH(MAX(MMULT($D$3:$D$10{1})),MMULT($D$3:$D$10,{1}),0))
The Visual: