User doubleunary

8 votes

Combine two columns into a list of all possible combinations of entries

answered May 19, 2021 at 15:28

6 votes

Formula to count rows between positive values

answered Apr 13 at 15:20

5 votes

Accepted

Is there a way to return multiple columns with XLOOKUP within an ARRAYFORMULA?

answered Dec 18, 2023 at 7:25

5 votes

How to insert timestamp when using either of the Fill Color tool or the Paint Format tool

answered Oct 30, 2021 at 10:06

4 votes

Accepted

Multivalue checkbox in Google sheets

answered Jan 24, 2022 at 16:26

4 votes

Accepted

Text input if cell > than 1

answered May 16, 2022 at 21:55

4 votes

Accepted

Google Sheets - Group/Aggregate data

answered May 27, 2022 at 9:20

4 votes

Accepted

Text result of JOIN is longer than the limit of 50000 characters

answered Jun 17, 2022 at 7:29

4 votes

"You have reached your limit of named versions" when naming a version

answered May 26, 2021 at 17:00

4 votes

Accepted

How to force uniqueness of cell in Google Spreadsheet with non-Latin text in cell?

answered Nov 14, 2023 at 10:21

4 votes

Accepted

Google Sheets: how to format currency with numbers right-aligned but +/- and $ left aligned and padded with spaces?

answered May 24 at 22:01

4 votes

Accepted

MATCH within a BYROW LAMBDA in Google Sheets

answered Dec 8, 2022 at 14:17

4 votes

Accepted

Google Sheets lookup with contains condition

answered Feb 6, 2023 at 17:04

3 votes

How to split a string into array of characters?

answered Feb 7, 2023 at 9:35

3 votes

Accepted

How do I check a set of numbers in different columns against numbers in different columns

answered Feb 9, 2023 at 10:34

3 votes

Accepted

Why does my conditional formatting not work with this formula?

answered Jan 7, 2023 at 18:22

3 votes

Accepted

How to chart a sum of categorised values

answered Jan 8, 2023 at 22:54

3 votes

Accepted

Exempting a cell containing a specific character

answered Dec 12, 2022 at 22:28

3 votes

Accepted

How could one use filter in multiple columns to use the maximum value and return the row name that it belongs to?

answered Dec 4, 2022 at 18:14

3 votes

Accepted

How to parse RFC3339 with TZ to field so that Google Sheets recognizes it as valid datetime stamp

answered Dec 29, 2022 at 8:26

3 votes

Accepted

Differentiating between 0 and empty cell with VLOOKUP in Google Sheets

answered Mar 13, 2023 at 8:30

3 votes

Accepted

Append Current Stock Stock Price to Historical Prices

answered Mar 14, 2023 at 18:16

3 votes

Why are the share button and toolbar blue in Google Sheets?

answered Mar 16, 2023 at 9:35

3 votes

Accepted

Does importrange not work on Google Sheets embedded XLSX files?

answered Jun 4, 2023 at 9:25

3 votes

Accepted

How to automatically add 00 minutes to hours in Google Sheets?

answered Jul 19, 2023 at 15:14

3 votes

Accepted

How do I modify my script to unhide all sheets subject to multiple exceptions?

answered Aug 9, 2023 at 21:22

3 votes

Highlighting only text for google sheets

answered Apr 16 at 18:04

3 votes

alphanumerics in duration in sheets - how to convert to a number of minutes

answered Apr 11 at 7:38

3 votes

Inserting signatures in cells

answered Jul 5 at 21:10

3 votes

Accepted

How can I write A2:A and not get any results for empty cells

answered Sep 27 at 13:43

Stack Exchange Network

1,089 Answers

Combine two columns into a list of all possible combinations of entries

Formula to count rows between positive values

Is there a way to return multiple columns with XLOOKUP within an ARRAYFORMULA?

How to insert timestamp when using either of the Fill Color tool or the Paint Format tool

Multivalue checkbox in Google sheets

Text input if cell > than 1

Google Sheets - Group/Aggregate data

Text result of JOIN is longer than the limit of 50000 characters

"You have reached your limit of named versions" when naming a version

How to force uniqueness of cell in Google Spreadsheet with non-Latin text in cell?

Google Sheets: how to format currency with numbers right-aligned but +/- and $ left aligned and padded with spaces?

MATCH within a BYROW LAMBDA in Google Sheets

Google Sheets lookup with contains condition

How to split a string into array of characters?

How do I check a set of numbers in different columns against numbers in different columns

Why does my conditional formatting not work with this formula?

How to chart a sum of categorised values

Exempting a cell containing a specific character

How could one use filter in multiple columns to use the maximum value and return the row name that it belongs to?

How to parse RFC3339 with TZ to field so that Google Sheets recognizes it as valid datetime stamp

Differentiating between 0 and empty cell with VLOOKUP in Google Sheets

Append Current Stock Stock Price to Historical Prices

Why are the share button and toolbar blue in Google Sheets?

Does importrange not work on Google Sheets embedded XLSX files?

How to automatically add 00 minutes to hours in Google Sheets?

How do I modify my script to unhide all sheets subject to multiple exceptions?

Highlighting only text for google sheets

alphanumerics in duration in sheets - how to convert to a number of minutes

Inserting signatures in cells

How can I write A2:A and not get any results for empty cells