Thank You , very useful On Turkish verison of google sheets like you said instead of "," we use ";" and to select different columns we use "\" between columns.
Your Videos have been really Helpful. Do you have a work-around for this formula if you have combined cells? I have columns A,B,C combined into 1 cell, this formula tried to put the results for 2 & 3 in the combined cells.
Wow Awesome !! Thanks Although I've got a question after having tried on my document. The results appear in lines and not in columns, do you have any idea why? Thanks!
Hi, this video is very helpful, but i have encountered an issue. Let's take yours as example: For the stock number, i have change it to dropdown list, the list data from "Merge Data Source". so by right in sheet "Merge Data", if i choose the stock number, it should return the value i am looking for. But in this case, in "Merge Data" cell:B2, i selected the 4953-66-590, it should return the "running shoes" from "Merge Data Source", but it return the value "sneaker Boot", which is wrong result. and in "Merge Data" cell:B3 i selected the 5133-23-374, it should return the "Training Shoes", but it return the "Running Shoes" instead. Please advise where goes wrong and what should i do? Thank you
When you got rid of the iferror you were back to N/A. I hope you'd show a better way to return blanks. my tables are very big and the iferror makes it slow...
Are your tables actually very big or do you have a lot of blank rows below your data? If you have a lot of blank rows delete them. Most commonly I see spreadsheets where there are thousands of blanks rows below the data, which is where it gets slow.
Hi I have a question. I have a table which contains in order; Date, Name and 21 columns of Numbers(Percentage). What I want to do is to find the total percentage that corresponds with a Name and Date from - Date to. Can you help me please?
Hiya, I find your series of videos soo helpful i am always referring to them as you not only explain step by step, you also explain why things work the way it does. However i am stuck! I have a row of 9 columns : Column 1 has numbers, Column 2 has numbers, Column 3 has dates,Column 4 has numbers, Column 5 has numbers, Column 6 has dates, Column 7 has numbers, Column 8 has numbers, Column 9 has dates. I want to to list numbers from Column three different columns into one column. The data has to come from Columns 1,4,7 WITHOUT adding the numbers.Please HEELLLP!
hi i got a problem because when i try to use arrayformula there is erorr with mention that "Array Result was not expanded because it would overwrite data in the cell after" what is the solution?
Pardon Sir. I tried to write the formula like you did: ={SEQUENCE(1;3;2);SEQUENCE(1;3;6)} But my result: 2 3 4 6 7 8 It has to be one raw right, not two... Can you help to explain what happened about this situation?
Hi there I need your help to deal with a problem which is just making a barrier for me, I look up for one purchase order which is having different invoices, I just get the first invoice number, if you want i can give you the exact picture of my problem. I would be grateful if you can help me to solve it.
@@ExcelGoogleSheets thank you so much..i'ts work..my problem is, my acount goole languange that use " ; " as separator formula, and yeahh with "\" that's work for me..thanks..
Fantastic video! Never used sequence function before and combining it with vlookup is a stroke of genius 🙂 Thank you!
Thank you so much. I had to copy paste the formula one by one to get different columns a few days ago. This is a huge time saver.
This the best video on his subject i have ever watched on youtube. Thank you very much. People like make life on the internet more meaningful.
he is so on point here.
This is EXACTLY what I needed!! Thank you for the amazing explanation 💯
😊
Great stuff, never thought about using a VLOOKUP like this before. Thanks for the helpful vid!
This is such fantastic material! Saved me from going into the pits of a million formulas to achieve one thing!
Simply awesome. Thanks for sharing this.
:)
This was super helpful! You explained things so well. I am quite a beginner, so I appreciate the tutorial
Superb..,😘🤗🤗
Thank you, Great vedio, very much useful
Terrific, I have really been a fan of yours video very helpful thanks hundred thousand million times
Great to hear!
This really helped me. Thanks!!
This is really so great. Thank you for doing this!
I got to tell you this. you are an artist!!
This is Extremely Helpful! Thank you!!
Always a lot to learn..
Thanks for your guidance 🙂
Thank you very much. It helped me save a lot of my time.
Excellent Video !!
Thank you very much
thanks, Share this tips
Thank You , very useful On Turkish verison of google sheets like you said instead of "," we use ";" and to select different columns we use "\" between columns.
thank u, we use also "\" in Russian version
Brazil... dont WORK (\) (;) (,)... Only brings the first result.
What a great use of sequence function... Keep it up 👍
Very helpful -thank you!
You are amazing ✌️👌✌️👌✌️👌✌️
Just amazing!
You're a NINJA! :D
Exactly what i am looking for thanks so much!
Hi sir, Will this Array method saves the formula processing time when we have lot many rows, comparing to put formula for all rows.
Dear teacher thanks with love
Thank you! Your vids are fantastic :)
Excellent! Just improve my 12-column vlookup main sheet :)
Lovely! Thanks man.
Your Videos have been really Helpful. Do you have a work-around for this formula if you have combined cells? I have columns A,B,C combined into 1 cell, this formula tried to put the results for 2 & 3 in the combined cells.
Do we have gsheet application which we can install in our system and work
You're fuckin awesome. Keep up the great work ♥️
Wow
Amazing, thank you so much!!
Wow Awesome !! Thanks
Although I've got a question after having tried on my document. The results appear in lines and not in columns, do you have any idea why? Thanks!
ua-cam.com/video/ljvB2arCsNQ/v-deo.html
@@ExcelGoogleSheets Thanks 🙏 Sorry about that I guess I asked you the same question that everyone 😅Anyway, this is perfect, thanks again !
Hi, this video is very helpful, but i have encountered an issue. Let's take yours as example:
For the stock number, i have change it to dropdown list, the list data from "Merge Data Source".
so by right in sheet "Merge Data", if i choose the stock number, it should return the value i am looking for. But in this case, in "Merge Data" cell:B2, i selected the 4953-66-590, it should return the "running shoes" from "Merge Data Source", but it return the value "sneaker Boot", which is wrong result. and in "Merge Data" cell:B3 i selected the 5133-23-374, it should return the "Training Shoes", but it return the "Running Shoes" instead.
Please advise where goes wrong and what should i do? Thank you
Hey, the array doesn't work in MS 365 while merging the sequence functions.
When you got rid of the iferror you were back to N/A. I hope you'd show a better way to return blanks.
my tables are very big and the iferror makes it slow...
Are your tables actually very big or do you have a lot of blank rows below your data? If you have a lot of blank rows delete them. Most commonly I see spreadsheets where there are thousands of blanks rows below the data, which is where it gets slow.
Hi I have a question. I have a table which contains in order; Date, Name and 21 columns of Numbers(Percentage). What I want to do is to find the total percentage that corresponds with a Name and Date from - Date to. Can you help me please?
And the Name column contains Duplicates, so when I use vlookup it only gets me the first row
Ow my God!!!!! Thank you!!!
Please put link for the copy of sample sheet that you worked on
Спасибо! 💪🏼
mind. blown.
can vlookup be used to move data that is updated automatically?
Depends on what you mean by "move", but probably not.
Hiya, I find your series of videos soo helpful i am always referring to them as you not only explain step by step, you also explain why things work the way it does. However i am stuck! I have a row of 9 columns :
Column 1 has numbers, Column 2 has numbers, Column 3 has dates,Column 4 has numbers, Column 5 has numbers, Column 6 has dates, Column 7 has numbers, Column 8 has numbers, Column 9 has dates.
I want to to list numbers from Column three different columns into one column. The data has to come from Columns 1,4,7 WITHOUT adding the numbers.Please HEELLLP!
Try FLATTEN function
hi i got a problem because when i try to use arrayformula there is erorr with mention that "Array Result was not expanded because it would overwrite data in the cell after" what is the solution?
OK i got it... thanks
I am google sheet FC , ^_^ thank you
Pardon Sir. I tried to write the formula like you did: ={SEQUENCE(1;3;2);SEQUENCE(1;3;6)}
But my result:
2 3 4
6 7 8
It has to be one raw right, not two... Can you help to explain what happened about this situation?
={SEQUENCE(1;3;2)\SEQUENCE(1;3;6)}
ua-cam.com/video/ljvB2arCsNQ/v-deo.html
@@ExcelGoogleSheets Thanks Sir. I perfectly understood now :)
I even can do this ua-cam.com/video/bo3OUjfYYYA/v-deo.html
Thanks a lot 😊
Impressive...
Hi there I need your help to deal with a problem which is just making a barrier for me, I look up for one purchase order which is having different invoices, I just get the first invoice number, if you want i can give you the exact picture of my problem. I would be grateful if you can help me to solve it.
ua-cam.com/video/_qEc8CEgUl4/v-deo.html
@@ExcelGoogleSheets Thank you soooooooooooooooooo much bro
does this work anymore?
Yes
Hey, great video! However, it is not working for me. It is only returning 1 column. Can you please help?
Which version of Excel?
@@ExcelGoogleSheets I am using it on google sheets
did you use ARRAYFORMULA() around it?
What's your formula?
@@ExcelGoogleSheets hey thank you so much for pointing it out. Yes, it is working. Thanks a lot! Keep making such awesome videos!!
why the result not to the left, but to go down..?thnks
use \ in your case
ua-cam.com/video/ljvB2arCsNQ/v-deo.html
@@ExcelGoogleSheets thank you so much..i'ts work..my problem is, my acount goole languange that use " ; " as separator formula, and yeahh with "\" that's work for me..thanks..
A god amongst men.