How to count/tally entries?
 

Hi
I want to put a number by a name for each job a staff member does
Job Employee Count
brighton tony 1
london richard 1
brighton john 1
london tony 2
brighton john 2
london tony 3

This is the example of what I want ie tony has done three jobs but I want it
to count them up one at a time effectively giving each job a unique number
based on 'name and count'.
How can I do this?
Thanks

How to count/tally entries?
 

=COUNTIF(B$2:B2,B2) and copy down

"chrisk" wrote:

Hi
I want to put a number by a name for each job a staff member does
Job Employee Count
brighton tony 1
london richard 1
brighton john 1
london tony 2
brighton john 2
london tony 3

This is the example of what I want ie tony has done three jobs but I want it
to count them up one at a time effectively giving each job a unique number
based on 'name and count'.
How can I do this?
Thanks

How to count/tally entries?
 

Nice one, Thanks very much.
Would have never thought of that

"klswvu" wrote:

=COUNTIF(B$2:B2,B2) and copy down

"chrisk" wrote:

Hi
I want to put a number by a name for each job a staff member does
Job Employee Count
brighton tony 1
london richard 1
brighton john 1
london tony 2
brighton john 2
london tony 3

This is the example of what I want ie tony has done three jobs but I want it
to count them up one at a time effectively giving each job a unique number
based on 'name and count'.
How can I do this?
Thanks