Assigning a reference to unique values in a range without sorting

[HOGGL]

The title is perhaps not very clear and not sure if this can be done - BUT any idea how I allocate something a reference number but meeting certain criteria.

What i'm trying to do is to say if the product (col B) is live (status col A) and has a certain code (col C) allocate the first instance number 1 and then the next instance number 2 and so on. And if the code changes start again at number 1. If the status is INACTIVE then just blank.

Kind of put what i want the output to be in column E. So if we look at code 7200 the first live instance in row 4 so that has been given 1, then row 5 - 2 and row 7 - 3. Row 6 has started again at 1 because it's the first instance of a live 1001 product.

Don't really want to sort the data by code (I know there's a fairly simple formula I could use if i do this).

	A	B	C	D	E
1	STATUS	PRODUCT	CODE		DESIRED RESULT
2	LIVE	CGLE3001000	1000		1
3	INACTIVE	CGLE3001000	1000
4	LIVE	CGLE3007200200325	7200		1
5	LIVE	CGLE3007200200225	7200		2
6	LIVE	CGLE3001001	1001		1
7	LIVE	CGLE3007200200325	7200		3
8	INACTIVE	CGLE3007200200325	7200

<tbody>
</tbody>

Hoping there's an answer.

Thanks in advance.

 

[Weazel]

maybe something like...

=IF(A2="inactive","",COUNTIFS($A$2:A2,"Live",$C$2:C2,C2))

 

[HOGGL]

Apologies for the delayed response but that worked perfectly. THANKS!