Count sequence of occurrence in a column with a criteria based on another column

[gulatinaveen]

Hi,
I am trying to solve a particular issue (sample data attached).

Note: I use Tables functionality

My table has 2 columns, 1 Date and Second as phone number. I need to solve two issues here in two new coulmns.
1. Need to know how many times a phone number occurs on a particular date - can use countifs to solve this issue, am able to solve this out
BUT i am not able to solve my second issue
2. Need to know the sequence of the number of times a number appears in the column DATE wise. i.e. if on 1st July a number appears three times and on the 2nd July the same number appears 2 times then my data should look something like this

See in the table attached, I used formula in "Sequence of Occurrence" Column as COUNTIFS($B$2:B2,B2) to get s result as shown. But what I am looking for is the result as in column "Sequence per day".
Also do note I use Table formulas and the dataset is very large.

Date	Number	Sequence of occurrence	Sequence per day
02-07-2022​	7019833873​	1​	1​
02-07-2022​	7019833873​	2​	2​
02-07-2022​	7019833873​	3​	3​
02-07-2022​	7019833873​	4​	4​
01-07-2022​	7829893336​	1​	1​
01-07-2022​	7829893336​	2​	2​
02-07-2022​	7829893336​	3​	1​
02-07-2022​	7829893336​	4​	2​
06-07-2022​	7829893336​	5​	1​
06-07-2022​	7829893336​	6​	2​
06-07-2022​	7829893336​	7​	3​
20-07-2022​	7829893336​	8​	1​
20-07-2022​	7829893336​	9​	2​
24-07-2022​	7829893336​	10​	1​
24-07-2022​	7829893336​	11​	2​

 

[Fluff]

Hi & welcome to MrExcel.
How about

=COUNTIFS(A$2:A2,A2,B$2:B2,B2)

 

[gulatinaveen]

Thanks a ton Fluff,
It was so simple and I was confused..... I guess too much of numbers is taking a toll on me.... LOL

Thanks anyways

 

[Fluff]

You're welcome & thanks for the feedback.