Rank within different segments

[alizok]

Can someone help me on Ranking formula within different segments. for exaple i have 6 different segments that is in column A and than different numbers in column B i need to rank these numbers by segment. The segment are not sorted so it could be segment 1 in column A1 with number 32 in column B and then segment 5 in A2 with different number. Is there a way for me to rank nubers in colum B without sorting it by segment? Any suggestion is a great help.
thank you very much

 

[Aladin Akyurek]

The ROW(INDIRECT("3:279")) part should always start with 1, change to

ROW(INDIRECT("1:277"))

Might be easier to update...

{=MATCH(B13,SMALL(IF($A$3:$A$279=A13,$B$3:$B$279," "),ROW(INDIRECT("1:"&ROWS($A$3:$A$279)))),0)}

 

[fairwinds]

Cool!

to be honest I have never used ROWS had to look it up in the help file.