How to count/tally entries?

C

chrisk

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count values in column only if value of another column is true 4
I want to tally my sheet 6
VLookup with multiple conditions 9
Access Report - Field to toal Group Totals 1
multiple criteria count formula with duplicate data 10
Count unique 4
Count with 1 variable & 1 constant criteria formula 3
Conditional maximum 3

Top