Thank you for your video. How can you sort out the responses from the "Other", where respondents can enter their own answers, in the checkboxes option, and put them in Google Sheet or Excel? Thank you very much.
Find(H$1;G2) ou trouve(H$1;G2) Les cases contenant des chiffres vous pouvez les remplacer par 1, et les valeurs contenant #VALEUR! Vous pouvez les remplacer par 0
If the form responses are being shared on a regular basis, is there a way the data can be parsed without having to take the data separately every time to analyse?
Yes, there are several ways to parse form responses without having to manually collect the data every time. One way is to use a spreadsheet program such as Microsoft Excel or Google Sheets to automatically import the form responses and organize the data into a structured format. This can be done using a tool called "data import" or "data connection" that allows you to connect the spreadsheet to the form and automatically update the data as new responses come in. Another way is to use a data analysis software such as R or Python to automate the process of collecting and analyzing the data. These tools can be programmed to automatically pull the data from the form and perform the necessary calculations and analysis. Additionally, some form builders also have inbuilt data analysis feature which can be used to process the data.
⚠ To anyone watching this: the shown formula in the video searches substrings, not exact matches!!! For example, "R" will be found in "Crab". That's probably not what you want! The function you need is EXACT, not SEARCH. So, use this formula instead (if it doesn't work with ; try using , instead): =IF(EXACT(B$1;$A2);1;0). Also, you can remove duplicate values in a column (Data -> Remove Duplicates) so that you don't filter unique values by hand and you can Paste -> Transpose the cleaned-up data so that you don't have to copy and paste one column header at a time, just like Mohamed does in the video. Great video otherwise, thanks!
What if the case is reverse? Make the codding data (0/1; yes/no) in to the list of some criteria? Is it possible? If yes, I want some of tutorial of this case please🙏🏻
Hi! I try to apply the function you provided us, but after many attempts, it is still not working, all I receive is an Error response. Do you why this keeps happening? Is there another formula we can use instead? Thank you in advance for your answer! :)
@@MohamedBenhimaPhD Hello! I finally found what the issue was, in fact, I needed to use semicolons instead of commas: =IF(ISERR(SEARCH(K$1;$B2));"0";1) Now it works! I also found another way to do it: =IF(ISNUMBER(SEARCH(C$1;$B2)); "1";"0") Thank you for your video it really saves me a lot of time to code the multiple-choice questions. :)
![How to Analyze Select-All-That-Apply Survey Questions in Excel ✅ [MS FORMS!]](http://i.ytimg.com/vi/1DaUb1txMOY/mqdefault.jpg)
I have watched so so so many videos but you are the only one who did it clearly and perfectly, THANKYOU
Glad it helped!
Right 😅. I was about to cry 😂
This is brilliant thank you! Been looking for a trick like this for ages.
Glad it helped!
Great Video............Thanks Mohd. Benhima
Thanks for the encouragement, too
This formula helped a lot thanks 👍👍👍👍👍👍👍👍!
Thank you so much this is great, can you make a video for how to analyse the 'other' responses?
Thank you so much. It is very precise and informative. Perfect videos
Glad it was helpful!
So do i separately post this to spss ? Bcs once I post the whole questionnaire the original will be posted?
Thank you so much. You just saved me.
Thank you for your video. How can you sort out the responses from the "Other", where respondents can enter their own answers, in the checkboxes option, and put them in Google Sheet or Excel? Thank you very much.
Thank you soooo much you save my life ❤❤❤
This helps, thanks
It worked, thank you Mohamed!
Most welcome!
Thank you so much....I am happy after doing it ...a great vdo a great lesson n indeed a great mentor...thnx a lot .
Lots of best wishes for u
Most weclome
thank you sir, very helpful video
Most welcome
To analyse google form or excel is easy?
Many thanks🙏🏽
THANK YOU SO MUCH. YOU SAVE ME MAN
wow.. a life saver! ❤
How can we do it in SPSS?
ua-cam.com/video/5AbOHjQRNwY/v-deo.html
@@MohamedBenhimaPhD Thanks Alot
After this step how can I apply it on spss?
You can first open the file on spss. Then copy those columns from the spss file to your original spss file
may i know how to use it in spss
Thank you. 😊
Thank you so much🥰
I can't do it. It says that is not possible and maybe there is a syntax error. The phrase is correct and I can't understand what could I do to fix it.
There should be a way
The cell number should be accurate
@@MohamedBenhimaPhD It is accurate. I don't know what's hapenning
So after this how do i send this into the SPSS for analysis?
ua-cam.com/video/5AbOHjQRNwY/v-deo.html
it doesn't work for me..i use macbook
Thank you
Can I use that in spss ?
Yes, but after you do it in excel
Why do I keep getting the ?NAME# error when its 0?
I found the same problem too😢.
Did u find the solution to that problem?
Find(H$1;G2) ou trouve(H$1;G2)
Les cases contenant des chiffres vous pouvez les remplacer par 1, et les valeurs contenant #VALEUR! Vous pouvez les remplacer par 0
If the form responses are being shared on a regular basis, is there a way the data can be parsed without having to take the data separately every time to analyse?
Yes, there are several ways to parse form responses without having to manually collect the data every time. One way is to use a spreadsheet program such as Microsoft Excel or Google Sheets to automatically import the form responses and organize the data into a structured format. This can be done using a tool called "data import" or "data connection" that allows you to connect the spreadsheet to the form and automatically update the data as new responses come in. Another way is to use a data analysis software such as R or Python to automate the process of collecting and analyzing the data. These tools can be programmed to automatically pull the data from the form and perform the necessary calculations and analysis. Additionally, some form builders also have inbuilt data analysis feature which can be used to process the data.
I don’t understand the function you used
⚠ To anyone watching this: the shown formula in the video searches substrings, not exact matches!!! For example, "R" will be found in "Crab". That's probably not what you want! The function you need is EXACT, not SEARCH. So, use this formula instead (if it doesn't work with ; try using , instead): =IF(EXACT(B$1;$A2);1;0).
Also, you can remove duplicate values in a column (Data -> Remove Duplicates) so that you don't filter unique values by hand and you can Paste -> Transpose the cleaned-up data so that you don't have to copy and paste one column header at a time, just like Mohamed does in the video. Great video otherwise, thanks!
LIFESAVER !!1
Thank you! How would you display other options as Mohammed did not show that
What if the case is reverse? Make the codding data (0/1; yes/no) in to the list of some criteria? Is it possible? If yes, I want some of tutorial of this case please🙏🏻
Yes, as you suggested
Hi! I try to apply the function you provided us, but after many attempts, it is still not working, all I receive is an Error response. Do you why this keeps happening? Is there another formula we can use instead?
Thank you in advance for your answer! :)
It works properly
@@MohamedBenhimaPhD
Hello! I finally found what the issue was, in fact, I needed to use semicolons instead of commas:
=IF(ISERR(SEARCH(K$1;$B2));"0";1)
Now it works!
I also found another way to do it:
=IF(ISNUMBER(SEARCH(C$1;$B2)); "1";"0")
Thank you for your video it really saves me a lot of time to code the multiple-choice questions. :)
Am using office 36 and hp the formula is not working for me any assistance.
Very helpful thanks, but can use the qualitative data to python to code or it’s better to use it as quantitative data and make comments
Did you find answer?
thank u
how to make a diagram from this data
You can make a bar graph using excel
📌 For assistance with data analysis, kindly contact me via this email: datanalysis93@gmail.com or WhatsApp: +212619398603 / wa.link/l6jvny /
Facebook: facebook.com/benhima1/
Instagram: instagram.com/medbenhima2...
TikTok: www.tiktok.com/@mohamedbenhim...
LinkedIn: www.linkedin.com/in/mohamed-b...
Google Scholar: scholar.google.com/citations?...
Twitter: twitter.com/Mohamed_Benhima
WhatsApp: +212619398603 / wa.link/l6jvny
E-mail: Datanalysis93@gmail.com
UA-cam CHANNEL: ua-cam.com/channels/jlk.html...