Bring the highest number in column A, where the value in Column B = "Project"

Thanks,
JP
easycapitalAsked:
Who is Participating?
 
Saurabh Singh TeotiaConnect With a Mentor Commented:

Use this formula...

=Max(If(B1:B100="Project",A1:A100,""))

This is an array formula please enter by ctrl+shift+enter

Also you can adjust the ranges as per your data range...

Saurabh...
0
 
easycapitalAuthor Commented:
Excellent!
JP
0
 
easycapitalAuthor Commented:
I am wondering if the 9.2 rating is the highest rating in EE.
JP
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Saurabh Singh TeotiaCommented:

Nah the highest rating i have got so far is 9.8 ... ;-)
0
 
easycapitalAuthor Commented:
Saurabh,

I missed that I need one more column in the calculation.  It works as the following:

Bring the highest number in column A, where the value in Column B = "Project", and column C "North"

Would it be:  
=Max(If(And(B1:B100="Project", C1:C100="North",A1:A100,""))  ?

Thanks,
JP
0
 
easycapitalAuthor Commented:
=Max(If(And(B1:B100="Project", C1:C100="North"),A1:A100,""))  ?  Missed a ")"
0
 
Saurabh Singh TeotiaCommented:

You can use this....

=MAX(IF(B1:B100="Project")*(C1:C100="North"),A1:A100,""))  

Saurabh...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.