Questions tagged [google-spreadsheets]
Google Spreadsheets is a part of the Google Docs web app suite. Questions about Google Spreadsheets are off topic and should be asked on webapps.stackexchange.com, unless they specifically involve your computer or browser.
478
questions
0
votes
1
answer
52
views
Find stdev of values in col B where col A matches criteria
I have a sheet where column A is dates and column B is values. I want to find the stdev of values in B where the date in A is within the last 30 days.
I am able to do sums with a sumifs which works on ...
- 101
2
votes
1
answer
671
views
How to set a whole row equal to a value, using ARRAYFORMULA() ? (in Google Sheets)
I would like to set the contents of all cells in a particular row to have the same value, sort of like having a banner that runs across the entire width of the spreadsheet. I'm working in Google ...
- 23
0
votes
0
answers
45
views
How to verify calculations when Excel and Google Sheet give imprecise results [duplicate]
This question is similar to In Excel, when I enter 22222.09482 then I see 22222.0948199999 number in the formula bar but it isn't the same. It's about how to verify with precision.
A simple ...
- 177
0
votes
2
answers
46
views
How to determine cell value based on comparing other cells to find the fastest and slowest durations?
I have a set of columns in a Google Sheet which are calculating the average duration between two times. I would like to calculate a score in the cells marked with an X based on the calculated averages....
- 1,914
0
votes
1
answer
14
views
How to dynamically return in each row the number of occurences of a string found in every column?
I have data between H2:L where H is static but L can grow to a new column.
How to use something dynamic like an arrayformula to count the number of occurrences of certain strings inside every column ...
- 988
-1
votes
1
answer
38
views
Convert tally table to a table
I have a table in Google sheets which approximately looks like this:
Name
Red
Yellow
Green
Blue
Mark
1
John
1
Steven
1
Bill
1
I want to shorten it into this kind of table:
Name
Color
Mark
...
-2
votes
1
answer
733
views
Excel / Sheets: How do I filter addresses based on a list of zip codes?
I'm planning to mail some postcards to potential business contacts.
I've got a spreadsheet of 2,500+ addresses with columns including Name, Street Address, City, State, zip code, etc. that cover the ...
1
vote
1
answer
256
views
reference range in different sheet with Indirect column and row
I'd like to reference a range in a separate worksheet using indirect relative row and column notation, something like this:
=INDIRECT("'dataset'!R[0]C1:R[0]C4", FALSE)
instead of
=dataset!a1:...
- 113
0
votes
1
answer
2k
views
Len and substitute to return 0 if cell is blank?
I'm using BYROW to pull a string of dates from one sheet and make a list of those dates in a single cell on another sheet. Now I'm trying to use LEN and SUBSTITUTE to count the number of dates in that ...
2
votes
1
answer
489
views
Remove third-party Google Sheet Add-On and UI Menu
I installed Numerous.ai third-party Add-On for Google Sheets (CAREFUL - DO NOT INSTALL IT). I didn't like it, so I then deleted it from Add-Ons (Extensions --> Add-Ons --> Manage Add-Ons --> ...
- 201
0
votes
1
answer
182
views
Replace duplicates in-place (Excel or Google Sheets)
Is there in-built functionality to remove duplicates in-place in Excel (365) or Google Sheets across several columns? For example, consider this set of data:
The goal is to select the entire data ...
- 4,867
0
votes
1
answer
2k
views
Find next cell within column that is a number, starting from reference cell in another sheet
I think this sounds simple but I'm having a bit of trouble figuring it out.
I have 2 sheets, the Sample Sheet attached and an Input Sheet.
In the Input Sheet, I input one of the green shaded values (...
0
votes
1
answer
103
views
Combining sheets with different number of colums and rows
How can I combine two sheets with different number of rows and columns in Excel, Libre Office or Google Sheets? Example:
Sheet 1:
Name
Age
Phone
Mike
35
197 158 348
Dave
38
394 953 429
Sheet 2:
...
- 1
1
vote
1
answer
1k
views
Drag and a drop a range from one sheet to another sheet of the same workbook or spreadsheet in Excel/Google Sheet
I would like to move a range of cells that contains many formulas (some using absolute reference and some others using relative reference). If I just do Cut and Paste then the relative formulas will ...
1
vote
1
answer
237
views
Calculate the difference in days between dates between rows in Google Spreadsheets?
I have a date column. What formula do I use in Google Sheets to calculate the difference in days between rows?
I tried =DATEDIF(A2,A3,"D") but get the following:
- 630