Love it! Thanks for sharing 👏

great advanced information presented in a nice, rapid pace

@learnspreadsheets

2 жыл бұрын

That’s very kind feedback - thanks!

You RULE Dave. Quick question you were about to explain though, how does one use the SPLIT function over multiple rows without dragging?

@learnspreadsheets

Жыл бұрын

Hey Dave! 😃 let me have a look & I’ll reply separately!

@learnspreadsheets

Жыл бұрын

Formula is =ARRAYFORMULA(SPLIT(C4:C10," > ")) see it here: docs.google.com/spreadsheets/d/1Eanxpw_azblb4if46mtHOlTb-e7NFwjPmbi5Q1-Fr8w/edit?usp=sharing

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.

@learnspreadsheets

3 жыл бұрын

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

@michaelglasser3635

3 жыл бұрын

@@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.

@learnspreadsheets

3 жыл бұрын

Oh yay! Awesome… glad you found a way that works!

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?

@learnspreadsheets

2 жыл бұрын

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

Sir plz make videos for recording data at certain time interval

@learnspreadsheets

2 жыл бұрын

Sorry I don’t understand

@subhasishbhattacharya3754

2 жыл бұрын

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

Hello, is there a way to sort a column by most recent date? Thanks!

@learnspreadsheets

Жыл бұрын

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

Pls practice file in distribution pls sir

@learnspreadsheets

3 жыл бұрын

Ah sorry but I don’t have one with this video directly

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.

@learnspreadsheets

3 жыл бұрын

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