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
|