Max If Criteria 2 separate columns.

Velven

New Member
Joined
Nov 30, 2017
Messages
37
Hello Guys

I have a formula here.

Array Formula Needs to be Entered by CSV.
=Max(if(A:A=G2,C:D))

There's nothing wrong with the formula above. It's working perfectly fine.


However , I notice that if the column is separated. It will no longer work.

Let's say the results I want a max return instead of C:D. I would like C and G.

How do I do this ?
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Try
Code:
=SUMPRODUCT(--($A$1:$A$100=G2),$C$1:$C$100,$D$1:$D$100)
, adjust the ranges as required.

If it doesn't work, then provide a working example of values in the ranges and G2 and what expected output should be.

Otherwise, guesswork since your screen isn't visible and details are sparse
 
Upvote 0
That wont produce a max jack. Simple way to do it is with the max of two max formulas:

=MAX(MAX(IF(A:A=G2,C:C)),MAX(IF(A:A=G2,I:I)))

CSE entered.
 
Upvote 0

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top