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.
485 questions
0
votes
1
answer
40
views
How do I use red highlighting on every cell in a column, if that cell contains the letter "n" or the cell contains the word "no" (case-insensitive)?
I tried the following formula.
OR("n" == LEFT(TRIM(E2), "N" == LEFT(TRIM(E2)))
My formula did not work as expected.The background color is white.The background color is not red.I ...
0
votes
1
answer
53
views
Conditional formatting to check if any of a word has been entered before
I'm managing a google sheet that contains names of volunteers. This sheet is maintained by several people, and they occasionally add new names on this table.
The problem is, sometimes they add a ...
- 2,084
2
votes
3
answers
186
views
Change row number in multiple places at once with one cell reference
I have a database where all of the values of each form entry appear on one single row. Every additional form entry response appears on subsequent row.
I then take this info and copy the info in ...
0
votes
0
answers
18
views
How to make a timeline chart of events + date in Google Sheets? [migrated]
I asked Grok AI: How to plot a timeline of events with date in google sheets?.
Grok says to make two columns of data such as:
A
B
Event Name
Date
Project Start
2025-01-15
Meeting
2025-03-22
Deadline
...
- 1,077
-1
votes
1
answer
81
views
I want to calculate the average difference between 1 column of numbers [closed]
I am working on losing weight and i have a google sheet where i keep track of my daily morning weight and the weekly average (due to daily fluctuations).
But, i would like to somehow calculate how ...
3
votes
3
answers
371
views
Distribution in Excel using rounding
I have a bag of 15 cookies of 100 calories each. The members in my family are to be distributed cookies based on a recommended calorie allocation. These values are:
Person
Calorie Allocation
Cookies
...
- 218
1
vote
2
answers
362
views
Excel/Spreadsheet Formula Help: Splitting and Reimbursing Shared Expenses
I have a monthly expenses tracking spreadsheet with two sheets:
"Expenses Summary" → Contains a list of members and columns for "To Pay" (how much they owe) and "To Receive&...
- 11
0
votes
1
answer
88
views
How to update Excel data sheet from one to another based on specific column values?
I have a contact sheet with some missing/outdated phone numbers and misspelled names. Now I got a new contact sheet contains new data and some updates of the old data.
Here's a screenshot to clarify:
...
- 1
0
votes
1
answer
140
views
Why are these SUMIF and SUMIFS producing different answers
I have a table of (talk, venue, timeslot) tuples, alongside a column that indicates if that combination should be part of a schedule. Here's how it looks
Talk
Venue
Timeslot
Scheduled?
python
Aspen
9
...
- 103
7
votes
3
answers
348
views
How to sort a spreadsheet by "dan and kyu" rank?
In the game of go as well as in martial arts, shogi, for tea ceremonies and for flower arrangements, players have a rank expressed in dan and kyu.
Dan and kyu form a simple numerical system:
30 kyu &...
- 251
0
votes
1
answer
127
views
In a MS Excel spreadsheet, how do we average all numeric values in a given column?
Consider the following table of data...
Year
Tempurature(°F)
2000
30.3
2001
M
2002
36.1
2003
M
Notice that half of the values are a single char, or string, such as MThe other half of the values are ...
0
votes
0
answers
160
views
Editable table-data using google sheet and app script (HTML)
So I have this spreadsheet tab wherein it contains multiple data from column A - Q. There are only 5 columns that are editable. I used data-table to extract the data from the sheet to a webpage. It ...
0
votes
2
answers
201
views
How do I count unique but ignore one set word
Can any one tell me how to use countunique and ignore one word in a list.
=COUNTUNIQUE(C53:C72).
I wish to ignore the word "blank" in a column.
I'm unsure how to convert the countunique to ...
0
votes
1
answer
622
views
How to make an automatic recipe calculator
How can I use Excel or Google Sheets to make an automatic recipe calculator?
For example, the original recipe is specified in columns A-C:
The original recipe is 200g flour, 100g sugar, 50g margarine....
user325613
0
votes
1
answer
88
views
How can I keep multiple rows of data while only displaying one row, but the others show up when moused over or selected?
Basically, we have a rickhouse full of barrels. Each rick/slot is 3 levels/rows high. We have 180 ricks/slots, or 540 levels/rows. Each row is 10 barrels deep. So each barrel has a rick number, a ...
