Morning,
Any help on this would be greatly appreciated. I think I need to create a pivot table but have no idea really what one is, nevermind how to create it. What I'm trying to do is:
- on the sheet labelled students
- list all the students on the sheet 'input sheet' in column G
- then in the column next to their name in sheet 'students' is the number of times their name appears
(I have changed all students names to Student 1, etc.)
Many thanks
Last edited by Cmorgan; 04-11-2012 at 08:55 AM.
You should google "excel pivot table" first.
So would a pivot table be able to do this or is it going to be a formula? - I was looking for a point in the right direction.
Cheers
Yes, you can do it using pivot tables. Select name of the student as the row field and count of student name as the data field.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
So simple, many thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks