Frequency formula with Countif

[srizki]

Hello All,

I would like to count frequency of values in column A, so when I drag the formula down it should count the number of times the valued in column A appears up to the point where the formula is.
This is how I want.
[TABLE="width: 155"]
<tbody>[TR]
[TD]VALUES[/TD]
[TD]FREQUENCY[/TD]
[/TR]
[TR]
[TD]H&M[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]H&M[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]H&M[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]DJ[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]DJ[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]H&M[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]TEXAS[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]PINNER[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Sweden[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]UK[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]UK[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Denmark[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Netherland[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Sweden[/TD]
[TD="align: right"]2[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]


Thanks

 

[MrKowz]

Try:

Excel 2013/2016
	A	B
1	VALUES	Frequency
2	H&M	1
3	H&M	2
4	H&M	3
5	DJ	1
6	DJ	2
7	H&M	4
8	TEXAS	1
9	PINNER	1
10	USA	1
11	USA	2
12	Sweden	1
13	USA	3
14	UK	1
15	USA	4
16	UK	2
17	Denmark	1
18	Netherland	1
19	Sweden	2
Sheet1

Cell Formulas
Range	Formula
B2	=COUNTIF($A$2:A2,A2)

 

[srizki]

Thank you MrKowz

 

[MrKowz]

Thank you MrKowz

You're welcome - thanks for the feedback.

Have a great weekend!