GUys,
You have helped me immensely in the past since I am no excel expert, I just have to use it once in awhile in my job.
Situation: I have a set of Data that is scores of an audit.
Format: Data is straight forward 92.33 type stuff
Task: Enter the data in excel and then sort it against certain criteria. Specifically if it falls above 95 it goes here, 90-94 it goes here, 85-89 it goes here, etc. This data needs to fall into a bar chart that shows the number of data points in each bar and the average score of that bar. Based on the sorting above.
To you guys this may sound and be easy! I am a pretty simple guy when it comes to excel and I dont really know where to begin. Can you be of help? I would pay someone to do it, but the data is VERY proprietary and I cant give it to anyone. I will only have to do this once a year and I can save the spreadsheet and just plug in new info next year.
ANy ideas?
Thanks in advance!
Allen
You have helped me immensely in the past since I am no excel expert, I just have to use it once in awhile in my job.
Situation: I have a set of Data that is scores of an audit.
Format: Data is straight forward 92.33 type stuff
Task: Enter the data in excel and then sort it against certain criteria. Specifically if it falls above 95 it goes here, 90-94 it goes here, 85-89 it goes here, etc. This data needs to fall into a bar chart that shows the number of data points in each bar and the average score of that bar. Based on the sorting above.
To you guys this may sound and be easy! I am a pretty simple guy when it comes to excel and I dont really know where to begin. Can you be of help? I would pay someone to do it, but the data is VERY proprietary and I cant give it to anyone. I will only have to do this once a year and I can save the spreadsheet and just plug in new info next year.
ANy ideas?
Thanks in advance!
Allen