<div>
Do you mean this?<br />
<br />
Eg. &nbsp;If your data is in A2:B6, try in C2:<br />
<br />
=SUMPRODUCT(--($B$2:$B$6=B<wbr />2),--(A2&gt;=<wbr />$A$2:$A$6)<wbr />)<br />
<br />
or<br />
<br />
=COUNTIFS($B$2:$B$6,B2,$A$<wbr />2:$A$6,&quot;&lt;=<wbr />&quot;&amp;A2)<br />
<br />
copied down.
</div>


Do you mean this?

Eg.  If your data is in A2:B6, try in C2:

=SUMPRODUCT(--($B$2:$B$6=B2),--(A2>=$A$2:$A$6))

or

=COUNTIFS($B$2:$B$6,B2,$A$2:$A$6,"<="&A2)

copied down.

<div>
I am using Excel 2003 that without a countifs function?<br />
<br />
the first sentense return:<br />
1<br />
3<br />
2<br />
2<br />
1<br />
<br />
seems not correct...
</div>


I am using Excel 2003 that without a countifs function?

the first sentense return:
1
3
2
2
1

seems not correct...

<div>
e.g.Min for &quot;Asia&quot; is 2, so in column C should be all 2 for Asia
</div>


e.g.Min for "Asia" is 2, so in column C should be all 2 for Asia

<div>
<div class="content wysiwyg-content">
Working on excel :<br />
<br />
Segment &nbsp; &nbsp; Gp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Result<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Asia &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Asia &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Asia &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<br />
6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Regional &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Regional &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<br />
<br />
Third result column is based on the result of first two columns: <br />
- For same gp, detect the min value and show<br />
<br />
How to do? thanks!
</div>
</div>


Working on excel :

Segment     Gp               Result
2                 Asia                   2
5                 Asia                   2
3                 Asia                   2
6                Regional            1
1                Regional            1

Third result column is based on the result of first two columns: 
- For same gp, detect the min value and show

How to do? thanks!

Excel Ranking within a group

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