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
0
answers
3
views
How to Prevent Duplicate Entries in Google Forms and Notify Users Using Google Apps Script [migrated]
I'm working on a project where I need to prevent duplicate entries in a Google Form based on a barcode number field. When a duplicate barcode number is detected upon form submission, the submission ...
0
votes
0
answers
4
views
Google sheet ROI formula not working [migrated]
My google sheet formula isn't working as intended.
In order to calculate the ROI of an event im making I use different stats and make a big calculation of points at the ROI collumn [![Presentation of ...
0
votes
0
answers
5
views
How to return values horizontally in Google Sheets [migrated]
Say I have a column like this:
User1 Item1
User1 Item2
User1 Item3
User1 Item4
User1 Item5
User2 Item1
User3 Item1
How can I return them like this in a filter/lookup formula:
User1 ...
0
votes
1
answer
42
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 ...
0
votes
1
answer
29
views
Leave cell blank until data is entered when multiplying
I have very little experience with spreadsheets and computers in general compared to, I assume, all of you. So, if you could spell out the answer to the below question as clearly as possible, it ...
4
votes
1
answer
162
views
Consolidate Data from Multiple Columns into One Column
I have a dataset that looks something like this:
Customer
Col1
Col2
Col3
Bob
111
2221
Michael
112
Anna
113
2223
Rachel
114
2224
334
Person5
115
I'd like to put all data into one column, ...
0
votes
2
answers
30
views
formula to count in how many cells first digit is greater than second in last pair
Let's say I have row of cells A1:A10 with values like "46 64 76", "63 60" etc. Two or three pairs of digits separated by spaces. I need to count in how many cells in last pair ...
1
vote
1
answer
51
views
SUM of a range of durations in an XLSX-Formatted sheet always returns 0 or errors
Excel document
I have the following XLSX-formatted spreadsheet in Google Sheets
I'm trying to set a formula on cell R5 (colored in red) so that it adds up all the times in the range L4:N42 but ...
0
votes
2
answers
108
views
Get first and last values for a range
Say I have a range, A1:A27, and that range has a mix of empty and non empty values, I would like two functions: one to get the first non-empty value in the range, and one to get the Last non-empty ...
0
votes
0
answers
26
views
Importing a range of formulas from csv or txt file starts with ' in excel and sheets [duplicate]
I am generating some image URLs with a python script and converting them to a formula. I have tried saving it to both a CSV and a TXT file as others suggested, but both lead to the same problem:
After ...
0
votes
1
answer
89
views
How to get value using row and column search
I made a budget spreadsheet I'd like to use and have plugged in some numbers to ensure I'm doing everything correctly. I have two sheets: 1. for the budget i.e. I'd like to spend max $1000 for rent ...
0
votes
0
answers
112
views
Sync Google Sheet with Microsoft Form Responses
I have a Microsoft form and the responses are recorded in an Excel file. I want to sync this Excel file with a Google sheet to do some calculations there. Sometimes, some formulas break the connection ...
0
votes
1
answer
72
views
How can I get an aggregated count of rows grouped by two values and enforcing uniqueness on a third in Excel?
I have a Google Sheets spreadsheet which is connected to an external integration that automatically populates rows with new 'events' contained within one of the sheets. I want to create a second sheet ...
-1
votes
1
answer
53
views
Alpha-sorting multiple rows, empty cells for missing values
Say I have multiple columns:
A | B | C…
Bill | Bill | John
Adam | Fran | Nick
| Adam2| Adam
I’d like to alpha sort the rows in each column, and also add empty values in a cell if the cell ...
0
votes
1
answer
191
views
Using Array Formula with TEXTJOIN to separate with commas all non-blank fields in each row
I am trying to create an array formula function that will pull the values of all fields in each row (between columns F and V) and separate them by ',' when not blank (from within only the row). The ...