Count what Instance an Occurance is

[TheRogue!]

I've got a table. The headers for the table are individuals.
The first data row of the table is what group the individuals are in (either Red or Blue).

On the next row of data, in the table, I need it to count what instance the occurance is (not the total number of occurances).
The first time it comes accross the value Blue in the data it needs to report "1", the next time it comes across "Blue", "2" & so on.

I know that there are 5 people in the Red group & 4 in the Blue group, so COUNTIF doesn't help me. I need it to number the people in the Red group 1-5 & the people in the Blue group 1-4.

It is also possible that the data in the group row will change (someone from Blue may go to Red), so I need to do this dynamically, w/ a formula.

Example:

	STAN	EARL	JIM	CATHY	LIZ	MURRAY	LISA	ELI	PETE
1	BLUE	BLUE	RED	RED	BLUE	RED	RED	RED	BLUE
2	1	2	1	2	3	3	4	5	4
3
4
5
6

<COLGROUP><COL style="WIDTH: 48pt" span=10 width=64><TBODY>
</TBODY>

 

[Scott Huish]

In A3:
=COUNTIF($A2:A2,A2)

Copy across.

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	STAN	EARL	JIM	CATHY	LIZ	MURRAY	LISA	ELI	PETE
2	BLUE	BLUE	RED	RED	BLUE	RED	RED	RED	BLUE
3	1	2	1	2	3	3	4	5	4
Sheet1

 

[njimack]

I don't understand why COUNTIF won't suffice?

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	STAN	EARL	JIM	CATHY	LIZ	MURRAY	LISA	ELI	PETE
2	BLUE	BLUE	RED	RED	BLUE	RED	RED	RED	BLUE
3	1	2	1	2	3	3	4	5	4
Sheet1

 

[TheRogue!]

Found my answer, elsewhere - I wasn't using the COUNTIF function correctly.
The correct usage is: =COUNTIF($C$2:C$2,C$2) Copy across.

Just in case anyone else needs it.