Stock Spreadsheet – How to add new stock without using a cumulative total
Stock Spreadsheet – How to add new stock without using a cumulative total
Web Applications
Mutual friend partially visible on same facebook profile
Mutual friend partially visible on same facebook profile
How to remove predefined facebook-messenger questions in the new environment please?
How to remove predefined facebook-messenger questions in the new environment please?
Varying Number of Wayback Machine Captures Found
Varying Number of Wayback Machine Captures Found
How to make Zoom speakers display at top of screen?
Figured it out. You can’t be in “Full Screen” mode apparently. If you are, you only get the gallery view on the side … Read more
TRANSFORM ROW WISE DATA INTO ONE COLUMN CONSECUTIVELY based on the number of values in each row
This formula takes each question and its standard answers in a single row, and re-formats the data to the desired output. =query({query({A:I},”select Col1,Col2,Col3,Col4″);query({A:I},”select … Read more
Google maps save public transit layer
Google maps save public transit layer
Google sheets array search. Any help Much appreciated :)
Use filter(), like this: cell C2: =transpose( filter(A2:A, isnumber(A2:A), A2:A <= 101) ) …and: cellE2: =transpose( filter(A2:A, A2:A > 101) ) The isnumber(A2:A) … Read more
Where has the Gmail Compose/Reply window pop-out command gone?
SHIFT-click the Compose/Reply window’s (mis-named) Full Screen button: Note: SHIFT hover changes the button to a tooltip-less single arrow:
Filter function outputting results differently depending on greater or less than
Welcome! Please try =FILTER(J2:J21, (J2:J21<=101)*(J2:J21>0)) or =FILTER(J2:J21, (J2:J21<=101)*(J2:J21<>””)) (empty cells are less than 101, right?)
