<div>
I am wondering if the 9.2 rating is the highest rating in EE.<br />
JP
</div>


I am wondering if the 9.2 rating is the highest rating in EE.
JP

<div>
<br />
Nah the highest rating i have got so far is 9.8 ... ;-)
</div>



Nah the highest rating i have got so far is 9.8 ... ;-)

<div>
Saurabh,<br />
<br />
I missed that I need one more column in the calculation. &nbsp;It works as the following:<br />
<br />
Bring the highest number in column A, where the value in Column B = &quot;Project&quot;, and column C &quot;North&quot;<br />
<br />
Would it be: &nbsp;<br />
=Max(If(And(B1:B100=&quot;Proje<wbr />ct&quot;, C1:C100=&quot;North&quot;,A1:A100,&quot;&quot;<wbr />)) &nbsp;?<br />
<br />
Thanks,<br />
JP
</div>


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

<div>
=Max(If(And(B1:B100=&quot;Proje<wbr />ct&quot;, C1:C100=&quot;North&quot;),A1:A100,&quot;<wbr />&quot;)) &nbsp;? &nbsp;Missed a &quot;)&quot;
</div>


=Max(If(And(B1:B100="Project", C1:C100="North"),A1:A100,""))  ?  Missed a ")"

<div>
<br />
You can use this....<br />
<br />
=MAX(IF(B1:B100=&quot;Project&quot;)<wbr />*(C1:C100=<wbr />&quot;North&quot;),A<wbr />1:A100,&quot;&quot;)<wbr />) &nbsp;<br />
<br />
Saurabh...
</div>



You can use this....

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

Saurabh...

<div>
<div class="content wysiwyg-content">
Thanks,<br />
JP
</div>
</div>


Bring the highest number in column A, where the value in Column B = &quot;Project&quot;

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Bring the highest number in column A, where the value in Column B = &quot;Project&quot;

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