ranking winth group WITH DUPLICATE BUT without skipping numbers

[asallame]

hello , can u help me to ranking within group with duplicating within group but without skiping value as for example 1 2 2 3 4 4 5 6 7 ...... for each group with multi column

thank u

ranking within group.xlsx
	F
9	4
Group Wise Rank

4

 

[StephenCrump]

Do you mean something like this?

	A	B	C
1		Result	Rank
2	A	75	4
3	B	90	1
4	C	87	2
5	D	69	5
6	E	82	3
7	F	54	7
8	G	87	2
9	H	75	4
10	I	61	6
Sheet1

Cell Formulas
Range	Formula
C2:C10	C2	=1+SUMPRODUCT((Result>B2)/COUNTIF(Result,Result))

Named Ranges
Name	Refers To	Cells
Result	=Sheet1!$B$2:$B$10	C2:C10

 

[asallame]

at first thank u for your fast replay , but what i need is the column A HAVE TWO OR THREE GROUP AND THE RESULT WITHIN GROUP HAVE SOME DEFRENT AND SOME SAME RESULTS FOR EXAMPLE THE GROUP( A ) HAVE THAT RESULT 100 100 41 78 84 THEN THE RANK WHAT IN NEED IS ( 1 1 4 3 2) NOT ( 1 1 5 4 3) WHICH SKIP VALUE 2 , SORRY FOR MY BAD LANUAGE
THANK U

 

[Marcelo Branco]

Maybe...

Pasta1
	A	B	C
1	Group	Result	Rank
2	Group A	100	1
3	Group A	100	1
4	Group A	41	4
5	Group A	78	3
6	Group A	84	2
7	Group B	39	2
8	Group B	39	2
9	Group B	3	4
10	Group B	15	3
11	Group B	98	1
12	Group C	100	1
13	Group C	39	2
14	Group C	39	2
15	Group C	100	1
Plan5

Cell Formulas
Range	Formula
C2:C15	C2	=SUMPRODUCT(--(A$2:A$15=A2),--(B$2:B$15>B2),--(ROW(B$2:B$15)-ROW(B$2)+1=MATCH(A$2:A$15&B$2:B$15,A$2:A$15&B$2:B$15,0)))+1

M.

 

[asallame]

thank u soooooooooo much , but can doing it with vba ?

 

[Marcelo Branco]

You're welcome. Thanks for the feedback.

A formula is the best solution.

M.

 

[asallame]

You're welcome. Thanks for the feedback.

A formula is the best solution.

M.

thank u so much