Find number of payments make base on time

[TrungVL]

My table looks like this:

END TIME	ID	If first or second payment
6/7/2018 11) <tbody> </tbody>	a2b149c3
6/7/2018 10:33 <tbody> </tbody>	a2b149c3
6/7/2018 10:13 <tbody> </tbody>	a2b149c3

<tbody>
</tbody>

ID will appear multiples time followed by different end time. Endtime is formatted with hh:mm:ss

I want to extract the number of payment/action make by ID for 1st time, 2nd times, 3rd times...

 

[mse330]

You can try the below formula

Book1
	A	B	C
1	END TIME	ID	If first or second payment
2	06-07-18 10:45	a2b149c3	3
3	06-07-18 10:33	a2b149c3	2
4	06-07-18 10:13	a2b149c3	1
5	06-07-18 9:13	123	1
6	06-07-18 9:53	123	3
7	06-07-18 9:45	123	2
Sheet1

Cell Formulas
Range	Formula
C2	=SUMPRODUCT(--($B$2:$B$7=B2),--($A$2:$A$7))+1
C3	=SUMPRODUCT(--($B$2:$B$7=B3),--($A$2:$A$7))+1
C4	=SUMPRODUCT(--($B$2:$B$7=B4),--($A$2:$A$7))+1
C5	=SUMPRODUCT(--($B$2:$B$7=B5),--($A$2:$A$7))+1
C6	=SUMPRODUCT(--($B$2:$B$7=B6),--($A$2:$A$7))+1
C7	=SUMPRODUCT(--($B$2:$B$7=B7),--($A$2:$A$7))+1