## Creating a formula to add data together

The requirements are very much unclear. Based on the limited information available, the best solution I can think of is to use query() … Read more

## How to transfer the ownership of a Google Sheets document to another account outside of the Google Workspace organization without losing cell history?

The method of cross-domain transfer with preserving file IDs using Google Shared Drives is well described here. Summary: Setup Google Shared Drive. Neutralize … Read more

Welcome! Such a table transformation is not very complicated, it can be done with three simple formulas. Put the formula ={“User ID”;UNIQUE(A2:A)} in … Read more

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

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

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

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

## How to write an ARRAYFORMULA which removes values with brackets [ ]?

You can get a subset of rows in a column or multi-column range with the filter() function. To use a condition like “the … Read more

## Counting names against actions

Counting names against actions

## What is the same-sheet equivalent of IMPORTRANGE?

What is the same-sheet equivalent of IMPORTRANGE?