In YouTube, how to filter comments – by popularity. Because it does not work anymore

YouTube forcefully stealing attention and time, by not letting anymore to filter comments by popularity. Instead button function now is popular comments mixed with not popular more then not I guess. How to bypass that?
P.s if possible leave credit for places you yourself learnt.

Go to Source
Author: Timer Tak

Query or filter the data when using date time format

Googlesheet: https://docs.google.com/spreadsheets/d/1hO_KatnkP58wuF6I7kwtlGgCI6xM6ubopgCwuYMXXIU/edit?usp=sharing

Sheet2

In cell A2 I have:
=QUERY(Sheet1!A1:Q, “Select * where B >= datetime ‘”&TEXT($A$1,”MM-DD-YYYY HH:mm:ss”)&”‘”)

In cell A1 I have:
6/17/2020 10:53:22 AM

Sheet1:
Column A (user) and B (date and time)
User1 6/17/2020 10:53:22 AM
User2 6/17/2020 10:53:22 AM
User3 6/17/2020 11:10:55 AM
User4 6/17/2020 11:33:57 AM
User5 6/24/2020 10:47:34 AM
User6 6/25/2020 4:50:39 AM
User7 6/24/2020 4:00:24 AM
User8 7/4/2020 5:44:25 AM
User9 7/4/2020 7:08:29 AM
User10 7/4/2020 8:49:24 AM
User11 7/3/2020 7:36:46 AM

The expected output in A2 Sheet2 is:
User1 6/17/2020 10:53:22 AM
User2 6/17/2020 10:53:22 AM

but the query I used outputs all of the data from Sheet 1.

Hope someone can help me…

Go to Source
Author: KB John

importing from multiple workbooks for Google Sheets to ignore workbooks that have nothing listed, instead of returning an error

={FILTER(IMPORTRANGE(“116uNZi52pAQe1_D_ZLNuD18gSx3zfB1P08TL2cT7Vdk”, “Trade and Manufacture!P17:T”), IMPORTRANGE(“116uNZi52pAQe1_D_ZLNuD18gSx3zfB1P08TL2cT7Vdk”, “Trade and Manufacture!P17:P”)<>””);FILTER(IMPORTRANGE(“1tWboZO37-_V5nJTNNxRhlvCIONLwHU43iie67zg4IU4”, “Trade and Manufacture!P17:T”), IMPORTRANGE(“1tWboZO37-_V5nJTNNxRhlvCIONLwHU43iie67zg4IU4”, “Trade and Manufacture!P17:P”)<>””)}

I am using Google sheets as a management system for a game I play in my classroom with my students. I was able to make a dynamic trading table – as in the students can post a trade good for sale in their workbook, and then it populates to this range (in a separate book) and then is sent to every student’s workbook.

This line is just for me testing if it worked across two workbooks, and it will be expanded to more of them – so this function will get larger. The problem I am having is that during testing with items listed – formula works great. The moment either of the two testing workbooks has NOTHING in the trade offers – it breaks. “Array Literal was missing values in one or more rows” I want it to ignore that and just post what is has available, and not break if even one country is not selling something.

Caveats
This code will be expanded to pull from more workbooks, so please note what has to be repeated vs what just applies to the single line of code.

Yes I know I should probably learn a coding language to make this work better (if you saw the rest of this workbook….. ) but I am a teacher and spare learning time is at a premium right now.

I do have an active script to make a dynamic drop down in another part of the workbook, so if a new script is needed I am not opposed to it – I just won’t be able to do it from scratch.

Go to Source
Author: Matthew Baptiste-Cerra