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.
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.
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
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 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?
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 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?
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 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.
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?
@@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.
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!
This is Extremely Helpful! Thank you!!
This was super helpful! You explained things so well. I am quite a beginner, so I appreciate the tutorial
This is really so great. Thank you for doing this!
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.
Exactly what i am looking for thanks so much!
Always a lot to learn..
Thanks for your guidance 🙂
What a great use of sequence function... Keep it up 👍
I got to tell you this. you are an artist!!
Thank you! Your vids are fantastic :)
This really helped me. Thanks!!
Lovely! Thanks man.
Amazing, thank you so much!!
Excellent Video !!
Thank you very much
Just amazing!
Very helpful -thank you!
Thank you very much. It helped me save a lot of my time.
Excellent! Just improve my 12-column vlookup main sheet :)
Thank you, Great vedio, very much useful
Superb..,😘🤗🤗
Terrific, I have really been a fan of yours video very helpful thanks hundred thousand million times
Great to hear!
Ow my God!!!!! Thank you!!!
thanks, Share this tips
Hi sir, Will this Array method saves the formula processing time when we have lot many rows, comparing to put formula for all rows.
You are amazing ✌️👌✌️👌✌️👌✌️
Simply awesome. Thanks for sharing this.
:)
Спасибо! 💪🏼
Dear teacher thanks with love
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.
You're a NINJA! :D
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.
You're fuckin awesome. Keep up the great work ♥️
mind. blown.
A god amongst men.
Wow
I am google sheet FC , ^_^ thank you
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
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!
ruclips.net/video/ljvB2arCsNQ/видео.html
@@ExcelGoogleSheets Thanks 🙏 Sorry about that I guess I asked you the same question that everyone 😅Anyway, this is perfect, thanks again !
Do we have gsheet application which we can install in our system and work
Please put link for the copy of sample sheet that you worked on
Hey, the array doesn't work in MS 365 while merging the sequence functions.
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
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 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
Impressive...
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 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.
ruclips.net/video/_qEc8CEgUl4/видео.html
@@ExcelGoogleSheets Thank you soooooooooooooooooo much bro
does this work anymore?
Yes
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)}
ruclips.net/video/ljvB2arCsNQ/видео.html
@@ExcelGoogleSheets Thanks Sir. I perfectly understood now :)
I even can do this ruclips.net/video/bo3OUjfYYYA/видео.html
Thanks a lot 😊
why the result not to the left, but to go down..?thnks
use \ in your case
ruclips.net/video/ljvB2arCsNQ/видео.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..
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!!