Example; find max in A when in B are 1!

A B

4500 0

4000 1

3500 1

3000 1

2500 0

Is this a test?

No, this is not a test, I found this case and I simplified it here.

If we put in the other column, =if(B=1,A,0) so then simply put Max fuction somewhere, it can solve the case, BUT i want just stright forward without using other column.

Thanks for telling us what you want. At some point are you planning on actually

askingfor help?

Yes i do, i am looking for help. Thanks.

Keep in mind that we are all volunteers at this site, giving of our time freely. I doubt you would walk into a co-worker's office and just blurt out what you want. My assumption is that you would politely

askthem for assistance. It should be no different in an online forum.When you ask nicely, you'll find that people will want to help you .

Try this array formula, which must be entered using Ctrl-Shift-Enter.

=MAX($A$1:$A$5*($B$1:$B$5=1))

After you enter it with Ctrl-Shift-Enter, it will have brackets around it like this:

{=MAX($A$1:$A$5*($B$1:$B$5=1))}

Let us know if that works for you.

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History