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 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!!
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?
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
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.
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
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.
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!!!
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?
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)
![Sean Rii, Karyon, Sharzkii - Taungule [My Love] (Official Music Video)](http://i.ytimg.com/vi/eJoMuypbSzQ/mqdefault.jpg)
Thank you so much, I was literally stuck at spreadsheet for almost 6 hours and almost ended up using multiple spredsheet files.
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
THANK YOU!! you have no idea how much this helped
Love You, Jamie, This is Very Helpful. Thank You!
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
Thank you, that was helpful and you got right to it, didn't waste my time.
Thank you so so much! This helped me a lot!
Thank you so much. You are a savior 🙏 🙌
THANK YOU SO SO MUCH FOR THIS!
Amazing! Thank you!!!
Thank you so very much!!!
Really helpful I was looking for the same
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!!
Thanks you saved my life
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?
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
thanks to this it really helps
This was actually extremely helpful I’m surprised because most of these kinds of videos suck
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.
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
how can i input data from above row table? or automatic short data from the new insert data
finally it works!
This Video realy helps
=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.
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?
Is there a way to link separate SHEETS together, as opposed to separate tabs?
greet mam
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
When I try it will display it with the query all within one line I’m not sure what my issue is!
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 ?
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
Hey your formula is not visible .Can you write the same in reply?
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?
hi if my data are on going , can we still use these steps?
how to genrat teport ti excel sheet to thypothisi
Does this work the same in excel?
How to make a chart out of this data?
How to automatically move data from google sheet to another sheet after One hour. Automatically after every one hour.
did not work
Maybe you can change "," with ";"
I don't know why, I copied your cell the same but still doesn't work
The formula u given in comment not working please help
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)