Count and Match Formula

[JoeRooney]

Hi , I need some assistance with a count and match formula to count unique values

I need to count unique values in order as they appear in the spreadsheet , I have gave an example below of the result i would like to get in column B.

Thanks

Policy	Count
ABC	1
ABC	2
ABC	3
DEF	1
DEF	2
DEF	3
DEF	4
GHI	1
GHI	2

 

[etaf]

assuming in column A

=countif($A$2:A2,A2)

Book1
	A	B	C
1	Policy	Count
2	ABC	1	1
3	ABC	2	2
4	ABC	3	3
5	DEF	1	1
6	DEF	2	2
7	DEF	3	3
8	DEF	4	4
9	GHI	1	1
10	GHI	2	2
Sheet1

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

 

[JoeRooney]

assuming in column A

=countif($A$2:A2,A2)

Book1
	A	B	C
1	Policy	Count
2	ABC	1	1
3	ABC	2	2
4	ABC	3	3
5	DEF	1	1
6	DEF	2	2
7	DEF	3	3
8	DEF	4	4
9	GHI	1	1
10	GHI	2	2
Sheet1

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

assuming in column A

=countif($A$2:A2,A2)

Book1
	A	B	C
1	Policy	Count
2	ABC	1	1
3	ABC	2	2
4	ABC	3	3
5	DEF	1	1
6	DEF	2	2
7	DEF	3	3
8	DEF	4	4
9	GHI	1	1
10	GHI	2	2
Sheet1

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

Works perfect, thank you

 

[etaf]

you are welcome