Hi everyone,
I've been swearing at my laptop for the last 2 hours trying to sot what is probably a very simple problem, before I feed it to the oven, can someone help:
I’ve got a grid of data on excel stating the results of a staff survey. Each member of the team has been marked 1-4 (1=good, 4=bad ect) on 18 separate questions.
What I now want to do is be able to collate this data and get excel to tell me how many 1's 2's 3's and 4's there are in each separate column. From this I can then (hopefully) make a nice graph to send upstairs so that the boss can easily see the results.
Is there a function that will allow me to do this or should I give up and go home?!?
Any help would be brilliant!