This video saved my life. I wanted answers from a specific age bracket only and I was about to go through them INDIVIDUALLY (I have 143 responses to this survey) to find the stats I wanted for my RP. I will forever be in your debt
I’m glad someone typed this out. The video doesn’t magnify the formula as it’s being written and each character is important for this formula to work. I think the content creator could do us all a favor and slow down a bit and and describe each keyboard stroke. Otherwise, without being able to see it on-screen very well, the viewer is left guessing.
Thanks, It works really well! But may i know how to modify the formula if we want to get the range from 2 columns? Let's say the "site" has 2 columns (From & To) (Column B & Column C) and we want to get the data that contains "LHS" that comes from column B & C
I've done query right from the response sheet, it's seems to work well. If I add data to the response sheet manually, will it effect the rest of the response sheet?
Hi tq for the video, can we filter with a query from a particular time and for a particular date in a timestamp column like it have 2, 3days data so I need to fetch only particular date and time data. Can u help me please?
Is there a way to query date from more than one column. I can sort names by one column but can not query three. I need to pull the names there column responses as they can be a leader, or helper and need to pull for both on same tab. tried this =QUERY('USE THIS SHEET FOR DATA'!A2:Z, "Select * Where D:F = 'Blair, A'") if is select just D, E or F it pulls data
Hi Jamie - thank you so much, this is SO helpful. I have just one additional question. How did you get the time and date stamp on there?? I can not figure it out!!
Once you connect your google form to google sheets, anytime the form is submitted, google sheets automatically includes a time stamp. I just realized you asked your question 6 years ago hopefully this helps lol
Jamie, need some help, I have a reservation system and people put in all different dates ie 17 july, 15december, 28 august etc.. at the moment I have them fill out the FORM and when the data comes into the SHEET I would like it to AUTOMATICALLY fall into date order vs doing it manually every time, any suggestions would be highly appreciated (i don't know formulas)..Thanks.
I have a question, as it seems as if u know sheets.lets say I I have data like Girl and Boy lets say I have someone tagged as girl but they are boy and I change it, how can I make it automatically move to a section on the Same Sheet?
Hi Jamie, Can the data on the sorted sheets (ie, LHS) be updated? I've created a similar sheet using a filter formula for teams to have their own tab of data, but if they need to make updates to the data...it all disappears!!!
Jamie, you are giving misinformation. Firstly, you can query the Form Responses 1 Sheet directly. Okay, I do prefer to transfer the Form Responses 1 sheet to another sheet for other reasons. Any way, secondly, you do not use the importrange() function to transfer data from one sheet to another in the same Spreadsheet workbook. Even though it does work it is inefficient. It would be like wanting to give a letter to a family member in the same house but instead of just walking over to them and handing it to them you put a stamp on it and take it to the post office. That will also work but you would not do it because it is inefficient. Hope that makes sense.
Hello Sir, May i know how to modify the formula if we want to get the range from 2 columns? Let's say the "site" has 2 columns (From & To) (Column B & Column C) and we want to get the data that contains "LHS" that comes from column B & C =Query('USE THIS SHEET FOR DATA' !A2:E, "Select * Where B = 'LHS'")
@@SuperVision5 If I am understanding you correctly you are saying column B or column C could have 'LHS' so you want to list all rows that has 'LHS' in column B or C. If that is the case then you can use =Query('USE THIS SHEET FOR DATA' !A2:E, "Select * Where B = 'LHS' or C = 'LHS' ")
@@benliebrand5271 Hi I found your answer in google Help but I have no I dea how to fix it, so could you please explain to me the query() of the filter() function. I have a problem with google sheet not appear when google form responses update and I am very new to excel. Sorry for bothering you and thank you. Ps. I try search youtube and found no helpful information that I can follow through (support.google.com/docs/thread/144087280?hl=en&sjid=11077057188261900266-AP)
Thank you so much, I was literally stuck at spreadsheet for almost 6 hours and almost ended up using multiple spredsheet files.
This video saved my life. I wanted answers from a specific age bracket only and I was about to go through them INDIVIDUALLY (I have 143 responses to this survey) to find the stats I wanted for my RP. I will forever be in your debt
Hi, I also have like 100+ responses for my survey, can I use excel filter instead of this formula and get it according to income level/age/ etc
I have literally been looking for some one to explain this for days. Thank you.
The best info for solving the challenge of too-long checkbox lines and/or long text options
This was actually extremely helpful I’m surprised because most of these kinds of videos suck
THANK YOU!! you have no idea how much this helped
=Query('USE THIS SHEET FOR DATA' !A2:E, "Select * Where B = 'LHS'")
I’m glad someone typed this out. The video doesn’t magnify the formula as it’s being written and each character is important for this formula to work. I think the content creator could do us all a favor and slow down a bit and and describe each keyboard stroke. Otherwise, without being able to see it on-screen very well, the viewer is left guessing.
Thank you So Much
Love You, Jamie, This is Very Helpful. Thank You!
Thank you so much. You are a savior 🙏 🙌
This Video realy helps
Thank you, that was helpful and you got right to it, didn't waste my time.
Thanks you saved my life
Really helpful I was looking for the same
THANK YOU SO SO MUCH FOR THIS!
Thank you so so much! This helped me a lot!
Amazing! Thank you!!!
Hey your formula is not visible .Can you write the same in reply?
thanks to this it really helps
Thanks, It works really well!
But may i know how to modify the formula if we want to get the range from 2 columns?
Let's say the "site" has 2 columns (From & To) (Column B & Column C)
and we want to get the data that contains "LHS" that comes from column B & C
did not work
Maybe you can change "," with ";"
Thank you so very much!!!
When I try it will display it with the query all within one line I’m not sure what my issue is!
Is there a way to link separate SHEETS together, as opposed to separate tabs?
finally it works!
how can i input data from above row table? or automatic short data from the new insert data
I've done query right from the response sheet, it's seems to work well. If I add data to the response sheet manually, will it effect the rest of the response sheet?
hi if my data are on going , can we still use these steps?
Hi tq for the video, can we filter with a query from a particular time and for a particular date in a timestamp column like it have 2, 3days data so I need to fetch only particular date and time data. Can u help me please?
Is there a way to query date from more than one column. I can sort names by one column but can not query three. I need to pull the names there column responses as they can be a leader, or helper and need to pull for both on same tab. tried this =QUERY('USE THIS SHEET FOR DATA'!A2:Z, "Select * Where D:F = 'Blair, A'") if is select just D, E or F it pulls data
Hi Jamie - thank you so much, this is SO helpful. I have just one additional question. How did you get the time and date stamp on there?? I can not figure it out!!
Once you connect your google form to google sheets, anytime the form is submitted, google sheets automatically includes a time stamp. I just realized you asked your question 6 years ago hopefully this helps lol
Jamie, need some help, I have a reservation system and people put in all different dates ie 17 july, 15december, 28 august etc.. at the moment I have them fill out the FORM and when the data comes into the SHEET I would like it to AUTOMATICALLY fall into date order vs doing it manually every time, any suggestions would be highly appreciated (i don't know formulas)..Thanks.
How to automatically move data from google sheet to another sheet after One hour. Automatically after every one hour.
hi about the survey can i seperate the names of the people who take the survey per sheet i hope you understand me sorry for my bad english
How to make a chart out of this data?
I don't know why, I copied your cell the same but still doesn't work
I have a question, as it seems as if u know sheets.lets say I I have data like Girl and Boy lets say I have someone tagged as girl but they are boy and I change it, how can I make it automatically move to a section on the Same Sheet?
Hi Jamie,
Can the data on the sorted sheets (ie, LHS) be updated? I've created a similar sheet using a filter formula for teams to have their own tab of data, but if they need to make updates to the data...it all disappears!!!
This method just permit you to updating data which is in the first sheet
The formula u given in comment not working please help
how to genrat teport ti excel sheet to thypothisi
Jamie, you are giving misinformation. Firstly, you can query the Form Responses 1 Sheet directly. Okay, I do prefer to transfer the Form Responses 1 sheet to another sheet for other reasons. Any way, secondly, you do not use the importrange() function to transfer data from one sheet to another in the same Spreadsheet workbook. Even though it does work it is inefficient. It would be like wanting to give a letter to a family member in the same house but instead of just walking over to them and handing it to them you put a stamp on it and take it to the post office. That will also work but you would not do it because it is inefficient. Hope that makes sense.
Hello Sir,
May i know how to modify the formula if we want to get the range from 2 columns?
Let's say the "site" has 2 columns (From & To) (Column B & Column C)
and we want to get the data that contains "LHS" that comes from column B & C
=Query('USE THIS SHEET FOR DATA' !A2:E, "Select * Where B = 'LHS'")
@@SuperVision5 If I am understanding you correctly you are saying column B or column C could have 'LHS' so you want to list all rows that has 'LHS' in column B or C. If that is the case then you can use =Query('USE THIS SHEET FOR DATA' !A2:E, "Select * Where B = 'LHS' or C = 'LHS' ")
@@benliebrand5271 you got me right, i have tried it and works perfectly as i need.
Thanks a lot for your help Sir
@@SuperVision5 That is great to hear :)
@@benliebrand5271 Hi I found your answer in google Help but I have no I dea how to fix it, so could you please explain to me the query() of the filter() function. I have a problem with google sheet not appear when google form responses update and I am very new to excel. Sorry for bothering you and thank you. Ps. I try search youtube and found no helpful information that I can follow through
(support.google.com/docs/thread/144087280?hl=en&sjid=11077057188261900266-AP)
Does this work the same in excel?
I was wondering does this work with numbers too? I can;t seem to get mine to work
Ya same issue... although I'm replying a bit late ...Do u know now what to do for numbers ?
greet mam