Create list of clustered numbers

[3G]

Hi there


I have a project number with multiple lines that has different people at each line. What I'm trying to so is assign a number to each person (i.e. 1, 2, 3, etc). Here's how the data looks:


Project Number|Project Name|Named Resource

2|System Remediation|Jack Sprat

2|System Remediation|Steve Stevens

2|System Remediation|Joe Bagodonuts

3|System Upgrade|Jack Sprat

3|System Upgrade|Steve Stevens

3|System Upgrade|Joe Bagodonuts


What I'd like to do is have the list look like this:

Project Number|Project Name|Resource Number|Named Resource

2|System Remediation|1|Jack Sprat

2|System Remediation|2|Steve Stevens

2|System Remediation|3|Joe Bagodonuts

3|System Upgrade|1|Dino Saur

3|System Upgrade|2|Barry Barebones

3|System Upgrade|3|Joe Bagodonuts


My formula looks like this:

=IF(C5=C4,ROWS($B$4:B4),B4+1)

However, once it reaches Project "3", it just puts "3", rather than starting over at 1.


Any thoughts?


thanks!

 

[prasaddn]

Hi 3G,


I assume you have headings in first row starting from A col. Please manually put 1 in Cell C2. And the below formula from C3 and drag down to whatever extent you have data.


=IF(A3=A2,C2+1,1)


Let me know if this addresses your problem.


Regards,

Prasad

 

[3G]

YESSS!!!!! Thanks PrasaddN!!!!!!