Help with Count occurrence and ignore if already exist based on criteria.

[Lukma]

Hi guys

Hope you all are doing just great, Please I have a slight issue and how to get around this

Am trying to count Column column A and I need my result in Column B based on the criteria
Example of what I need:
in column A I have 1 repeated twice, so I will need column B to count as 2 and when i drag down I need the next to be blank
I need the same result as this on the table

Appreciate your support

Range	Count
1​	2​
1​
2​	1​
3​	1​
4​	2​
4​

Data build up for Presentation( 23)update.xlsx
	A	B
132		Count
133	1	2
134	1	2
135	2	1
136	3	1
137	4	2
138	4	2
2023_Data_Vessel_Trip

Cell Formulas
Range	Formula
A132:A138	A132	=IFERROR(MATCH(DAY(H132),{1,8,15,22,29}),"")
B133:B138	B133	=SUMPRODUCT(($A$133:$A$138=$A133)*($A$133:$A$138>0))

 

[Sanjeev1976]

You can try :

Book2
	A	B
1	Range	Count
2	1	2
3	1
4	2	1
5	3	1
6	4	2
7	4
Sheet1

Cell Formulas
Range	Formula
B2:B7	B2	=IF(A2<>A1,COUNTIF($A$2:$A$7,A2),"")

 

[Lukma]

You can try :

Book2
	A	B
1	Range	Count
2	1	2
3	1
4	2	1
5	3	1
6	4	2
7	4
Sheet1

Cell Formulas
Range	Formula
B2:B7	B2	=IF(A2<>A1,COUNTIF($A$2:$A$7,A2),"")

Dear Sanjeev

Many Thanks

appreciate all your support

Regards