Help with if formula based on values

[kypok999]

Hi Guys need help with below formula as per image current formula is looking into ranking based on A2 which is fine but if I get duplicate value in column AM like line 5 and 6 I want it to give the same ranking in this case it would be 4 and 4

Thank you

Image:

https://imgur.com/a/WPaTs

 

[oldbrewer]

98					1	98	1
90					2	90	2	####
60					3	60	3
55					4	55	4
55					5	55	4
46					6	46	5		now shows rank 5 for 46
33					7	33	6
20					8	20	7
				using large function, then looking for duplications
				and if found use the rank of the first one
					####
					=IF(G2=G1,F1,H1+1)

<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[kypok999]

98					1	98	1
90					2	90	2	####
60					3	60	3
55					4	55	4
55					5	55	4
46					6	46	5		now shows rank 5 for 46
33					7	33	6
20					8	20	7
				using large function, then looking for duplications
				and if found use the rank of the first one
					####
					=IF(G2=G1,F1,H1+1)

<tbody>
</tbody>

Hello it fixed the 2,2 but not the rest I attached picture:

https://imgur.com/a/WWujV

 

[wideboydixon]

I already gave you the answer:

=IF(A1=A2,IF(AL1=AL2,AM1,AM1+1),1)

WBD

 

[kypok999]

I already gave you the answer:

=IF(A1=A2,IF(AL1=AL2,AM1,AM1+1),1)

WBD

Sorry WBD but results is not what i need please see picture below:
Image:
https://imgur.com/a/tan2f

 

[wideboydixon]

Book1
	A	AL	AM
1	concatinate	Spd Rtg	Spd Rnk
2	a	68	1
3	a	61	2
4	a	61	2
5	a	59	3
6	a	59	3
7	a	56	4
8	a	56	4
9	a	54	5
10	a	51	6
11	a	40	7
12	a	0	8
Sheet1

Cell Formulas
Range	Formula
AM2	=IF(A1=A2,IF(AL1=AL2,AM1,AM1+1),1)

I beg to differ ...

WBD

 

[kypok999]

	A	AL	AM
1	concatinate	Spd Rtg	Spd Rnk
2	a	68	1
3	a	61	2
4	a	61	2
5	a	59	3
6	a	59	3
7	a	56	4
8	a	56	4
9	a	54	5
10	a	51	6
11	a	40	7
12	a	0	8

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula AM2 =IF(A1=A2,IF(AL1=AL2,AM1,AM1+1),1) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

I beg to differ ...

WBD

Sorry I am complete nob... all fixed thank u

 

[wideboydixon]

Sorry I am complete nob... all fixed thank u

Haha. No problem. I won't ask what you did ...

WBD