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 ?
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 ?