Formula is =ARRAYFORMULA(SPLIT(C4:C10," > ")) see it here: docs.google.com/spreadsheets/d/1Eanxpw_azblb4if46mtHOlTb-e7NFwjPmbi5Q1-Fr8w/edit?usp=sharing
Question, say you have something like that unique formula that spills a list that can vary in size. Now, say I wanted to have a formula in the next column that interacted with this unique list. I'm not sure the best way to phrase this, but is there a way to essentially spill cells with a formula based on how many cells have been spilled by the unique formula?
Great video explaining lots of things. How can I get a top 10 of data from two non-consecutive columns? I want to return column A and column E, based on sorting of column E. I am having trouble with the syntax for getting the range of A and E in the SORTN function. Trying to avoid QUERY function, if possible. Thanks in advance for any suggestions.
There is either sortn and then hide the cols (as the function doesn’t let you choose columns) or you could do it with a pivot table (select which cols to appear where then add a filter), or to get exactly what you need it would be query
@@learnspreadsheets Thanks for the reply. Good idea with the hide functionality. I will say that I finally figured out a solution that worked for me, =sortn({Sheet1!A2:A999,Sheet1!E2:E999},10,0,2,false). Your tip on ARRAYFORMULA led me to {} notation and finally figured out commas separating columns is what I wanted and I kept trying semi-colons, which stack the data. Thanks for the video and the reply with tips.
Hey! Thanks for the feedback, the dynamic arrays topic is quite a complex one and I cover so much in this video! Point taken though, I’ll slow down when I can
Thanks sir I want to mean that results of the calculations will be stored in a cell with mentioned the time of the results as the calculations change then this result store in next cell with time For instance stock market option chain data real time variance analysis
great advanced information presented in a nice, rapid pace
That’s very kind feedback - thanks!
Love it! Thanks for sharing 👏
You RULE Dave. Quick question you were about to explain though, how does one use the SPLIT function over multiple rows without dragging?
Hey Dave! 😃 let me have a look & I’ll reply separately!
Formula is =ARRAYFORMULA(SPLIT(C4:C10," > ")) see it here: docs.google.com/spreadsheets/d/1Eanxpw_azblb4if46mtHOlTb-e7NFwjPmbi5Q1-Fr8w/edit?usp=sharing
Hello, is there a way to sort a column by most recent date? Thanks!
Hey yes there is with the SORT or SORTBY if you pick a date column & descending or I have another video on QUERY for more advanced stuff
Question, say you have something like that unique formula that spills a list that can vary in size. Now, say I wanted to have a formula in the next column that interacted with this unique list. I'm not sure the best way to phrase this, but is there a way to essentially spill cells with a formula based on how many cells have been spilled by the unique formula?
Hi I don’t think what you’re asking is possible, i would just leave some blanks around it to give it room to expand
Great video explaining lots of things. How can I get a top 10 of data from two non-consecutive columns? I want to return column A and column E, based on sorting of column E. I am having trouble with the syntax for getting the range of A and E in the SORTN function. Trying to avoid QUERY function, if possible. Thanks in advance for any suggestions.
There is either sortn and then hide the cols (as the function doesn’t let you choose columns) or you could do it with a pivot table (select which cols to appear where then add a filter), or to get exactly what you need it would be query
@@learnspreadsheets Thanks for the reply. Good idea with the hide functionality. I will say that I finally figured out a solution that worked for me, =sortn({Sheet1!A2:A999,Sheet1!E2:E999},10,0,2,false). Your tip on ARRAYFORMULA led me to {} notation and finally figured out commas separating columns is what I wanted and I kept trying semi-colons, which stack the data. Thanks for the video and the reply with tips.
Oh yay! Awesome… glad you found a way that works!
Any chance of slowing down your delivery? I find it difficult to keep up without pausing and going back. Pity because your content is excellent.
Hey! Thanks for the feedback, the dynamic arrays topic is quite a complex one and I cover so much in this video! Point taken though, I’ll slow down when I can
Sir plz make videos for recording data at certain time interval
Sorry I don’t understand
Thanks sir
I want to mean that results of the calculations will be stored in a cell with mentioned the time of the results as the calculations change then this result store in next cell with time
For instance stock market option chain data real time variance analysis
Pls practice file in distribution pls sir
Ah sorry but I don’t have one with this video directly