Max If Criteria 2 separate columns.

[Velven]

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 ?

 

[JackDanIce]

Try

=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

 

[steve the fish]

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.