+ Reply to Thread
Results 1 to 2 of 2

How do I compare (checkbox) columns from Google Forms with gender/***?

  1. #1
    Registered User
    Join Date
    05-10-2020
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2016
    Posts
    1

    How do I compare (checkbox) columns from Google Forms with gender/***?

    Hi,

    I really hope someone can help me, because I've spent the last 4 hours trying to solve this my self.

    I've made a survey regarding streaming and SoMe behaviour in Google Forms. One of the questions were "Which social media do you use?". Here I used the checkbox function In Google Forms with the possible answers Facebook, Instagram, Youtube, Snapchat etc. Now my Pivot table registers the ones who answered "Facebook" as on option, the ones who answered both Facebook and Instagram as another option, and the once who answered Facebook, Instagram and Snapchat as a third option. I want to separate each option so I can easily tell how many people answered "Facebook" and then compare it to their gender and ***.

    "Which social media do you use" is "Hvilke sociale medier bruger du? (Vælg gerne flere)" in the Excel sheet. I would like to compare it with the gender and the age. In the sheet it's the questions "Hvilket køn er du?" and "Hvor gammel er du?".

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How do I compare (checkbox) columns from Google Forms with gender/***?

    I used text to colum and komma as seperator.

    After that I used VBA code to get the data in verticaly way.

    After that I made a pivot table.

    See the attached file.


    It did not involved all data, but maybe you get started this way.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Google Forms: Using formula to find the line that matches criteria in 2 different columns
    By aloconnor in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 04-25-2019, 07:58 AM
  2. [SOLVED] Google Forms
    By MissDB in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 11
    Last Post: 03-01-2019, 04:05 AM
  3. inporting data from google forms
    By nappy1001 in forum Excel General
    Replies: 1
    Last Post: 09-20-2018, 04:32 PM
  4. Excel Survey like Google Forms
    By howaboutno in forum Excel General
    Replies: 8
    Last Post: 07-24-2016, 07:41 AM
  5. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  6. Google (sheets, forms, etc)
    By BRIZZLE101 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 04-03-2013, 08:55 PM
  7. Pivot Formula: Gender(male)/Gender(female)
    By peterso in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-04-2011, 04:23 PM

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