Top "Formulas" questions

A formula is a mathematical equation or expression that performs various operations on variables to produce an outcome.

Transposing data from column to row using references

I have some data in a row, say A1 to Z1, and I would like to link to this data …

excel excel-formula transpose formulas array-formulas
Insert a Newline in Excel Formula (MacOS)

I am using MS Excel on a Mac. I have a formula, and I wish to insert a newline into …

excel newline macos formulas
In Google Sheets, How do I find the row number of a cell with certain text in it?

In Google Sheets, What do I do if I want a cell to display the row number in which a …

google-sheets formulas google-sheets-query
Quotation marks and apostrophes in the same string in QUERY Google Sheets function

I'm wondering how one might handle a query like this. Let's suppose I had the following text contained in Cell …

google-sheets formulas google-query-language
How can I normalize / asciify Unicode characters in Google Sheets?

I'm trying to write a formula for Google Sheets which will convert Unicode characters with diacritics to their plain ASCII …

regex unicode google-sheets formulas re2
How to use native spreadsheet functions in google apps script?

Is it possible to use native spreadsheet functions such as sum() or today() in google apps script, when writing code …

google-apps-script google-sheets formulas
How to find the first cell in a row where value is not empty and check if the number is less or equal the number in other cell

I've got the following Google spreadsheet: item have ready need1 need2 need3 A 1 2 1 B 1 2 1 1 C 2 2 etc I want to fill …

google-sheets formulas
How to calculate Date Time Difference in LibreOffice Calc

I need to calculate the difference between two Date Time fields in LibreOffice Calc, with the answer in hours, positive …

time formulas libreoffice-calc
ArrayFormula a Filter in a Join (Google Spreadsheets)

I've done a lengthy search and couldn't find what I'm looking for. Maybe someone out there can kindly help? I …

google-sheets formulas array-formulas