google-sheets Archives

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?

by IT Nursery

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

Managing poll answer in a spreadsheet: grouping same questions

by IT Nursery

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

by IT Nursery

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

by IT Nursery

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 :)

by IT Nursery

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