+ Reply to Thread
Results 1 to 13 of 13

Best way to group survey results by ward reporting % of Yes NO N/A and Unknown results

  1. #1
    Registered User
    Join Date
    07-13-2018
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    8

    Best way to group survey results by ward reporting % of Yes NO N/A and Unknown results

    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
    Attached Files Attached Files
    Last edited by bPaulb; 07-14-2018 at 10:05 AM. Reason: To be compliant with rules

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    5,914

    Re: Best way to group survey results by ward reporting % of Yes NO N/A and Unknown results

    Link to CP was added
    Last edited by Pepe Le Mokko; 07-17-2018 at 12:20 PM.
    Be aware that this forum is insecure ! (images are not secure) - Use at your own risk

  3. #3
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    18,977

    Re: Best way to group survey results by ward reporting % of Yes NO N/A and Unknown results

    Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution is also shown (mock up the results manually).

    3. Make sure that all confidential information is removed first!!

    4. Try to avoid using merged cells. They cause lots of problems!

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Glenn



  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    20,161

    Re: Best way to group survey results by ward reporting % of Yes NO N/A and Unknown results

    Glenn - the cross-post request needs to be fulfilled before any help is offered, but yes, adding a file is a good idea.

    BPaulb - you must provide the cross-post information requested in post #2 before we continue, please.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  5. #5
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    18,977

    Re: Best way to group survey results by ward reporting % of Yes NO N/A and Unknown results

    No help was offered. In my view, it is unwelcoming to request a change, to wait for that change to be made, and then ask for a sample sheet. It is far better to get the OP to do both at once.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    20,161

    Re: Best way to group survey results by ward reporting % of Yes NO N/A and Unknown results

    Sorry, Glenn - my comment was really for the OP so that he/she understands that the help will not come until the cross-post issue is addressed, but that adding an attachment would be a good idea. My wording did not quite reflect that - sorry.

  7. #7
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    18,977

    Re: Best way to group survey results by ward reporting % of Yes NO N/A and Unknown results

    No problem!!

  8. #8
    Registered User
    Join Date
    07-13-2018
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    8

    Re: Best way to group survey results by ward reporting % of Yes NO N/A and Unknown results

    Oh dear my thank you for pointing out the rules corrected

  9. #9
    Registered User
    Join Date
    07-13-2018
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    8

    Re: Best way to group survey results by ward reporting % of Yes NO N/A and Unknown results

    Thank you for trying to help me Glenn!! New to all of this

  10. #10
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    18,977

    Re: Best way to group survey results by ward reporting % of Yes NO N/A and Unknown results

    I don't see how you get the manually calculated results in "Results" B4 to E5 from the data in "Data"....

    can you explain??

  11. #11
    Registered User
    Join Date
    07-13-2018
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    8

    Re: Best way to group survey results by ward reporting % of Yes NO N/A and Unknown results

    Hi Glenn The results data is just an example of layout. Thanks for you message!

  12. #12
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5,733

    Re: Best way to group survey results by ward reporting % of Yes NO N/A and Unknown results

    I could not follow the path to the mrexcel site so I have no idea whether or not this question has been answered, however if I understand correctly the following formulas should yield the desired results (although they are not even close to what was originally given).
    For column B: =COUNTIFS(Table1[Ward],A4)/COUNTA(Table1[Ward])
    For columns C:E
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  13. #13
    Registered User
    Join Date
    07-13-2018
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    8

    Re: Best way to group survey results by ward reporting % of Yes NO N/A and Unknown results

    thanks for getting back ... yes the sheet had evolved a bit. since the first question. I was looking for a vba macro.

    I need to make the results as a percentage without counting the n/a and no answers then graph everything.
    I cant do this as a pivot table as it just does not give results sadly

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1