max with criteria in different column

October 22, 2010 at 10:57:19
Specs: Windows XP
Example; find max in A when in B are 1!

4500 0
4000 1
3500 1
3000 1
2500 0

See More: max with criteria in different column

Report •

October 22, 2010 at 20:28:40
Is this a test?

Report •

October 23, 2010 at 12:16:06
No, this is not a test, I found this case and I simplified it here.

Report •

October 23, 2010 at 12:25:00
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.

Report •

Related Solutions

October 23, 2010 at 14:29:27
Thanks for telling us what you want.

At some point are you planning on actually asking for help?

Report •

October 24, 2010 at 13:30:38
Yes i do, i am looking for help. Thanks.

Report •

October 24, 2010 at 22:35:14
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 ask them 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.


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


Let us know if that works for you.

Report •

Ask Question