# 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!A B4500 04000 13500 13000 12500 0

See More: max with criteria in different column

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

Report •

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

Report •

#3
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

#4
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 •

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

Report •

#6
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.=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.

Report •