## Stock Spreadsheet – How to add new stock without using a cumulative total

Stock Spreadsheet – How to add new stock without using a cumulative total

## Mutual friend partially visible on same facebook profile

Mutual friend partially visible on same facebook profile

## 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?)