R
robzrob
I've got 6 worksheets (one for each workstation) in a workbook all
with various data (user who made entry, date entered, entered am/pm,
week entered, entry type, month entered, etc.) How can I set up
worksheet 7 so that I can count different things - eg number of
entries made by user A in the afternoons, number of entries of type B
made by user C at workstation D in April, total number of entries at
workstation E, etc, etc. I've tried a pivot table but can't get on
with it.
with various data (user who made entry, date entered, entered am/pm,
week entered, entry type, month entered, etc.) How can I set up
worksheet 7 so that I can count different things - eg number of
entries made by user A in the afternoons, number of entries of type B
made by user C at workstation D in April, total number of entries at
workstation E, etc, etc. I've tried a pivot table but can't get on
with it.