Not sure how to do this.
I've also posted this on MrExcel unfortunately I cannot post links
.mrexcel
/forum
/excel-questions
/1063040-best-way-group-survey-results-ward-reporting-yes-results.html
worksheet has the results of and audit. Y is that the ward was compliant for that question, N no, N/A and Unknown
column A has the wards audited
columns B-A0 have the answers to the survey Questions in the form of Y N N/A and Unknown
Please see attached file
Bookmarks