All Questions
105
questions
4
votes
1
answer
183
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
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
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
2k
views
MAX function not working on date with format dd/mm/yyyy in Google Sheets (Excel)
I'm using Google sheets and the MAX() function works only on dates with format mm/dd/yyyy. How to get the MAX() of date with format dd/mm/yyyy?|
0
votes
1
answer
609
views
Google Sheets - Making a chart where certain series do not have data for all X-axis values
I am making a chart for research in musicology which requires me to graph the duration and tempo of notes based on the score, i.e. musical values like a quarter note.
Using a recording of a string ...
-2
votes
1
answer
761
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 ...
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 (...
8
votes
4
answers
9k
views
Formula to see if a series of numbers is increasing in value?
I have a spread sheet with thousands of sets of numbers. That is too say, there are ten columns and each column has a number - and there are thousands of rows of these numbers.
What I want to do is ...
1
vote
2
answers
477
views
Using XLOOKUP or FILTER to aggragate data into a single cell
I have a data set that is compiled by various people filling out a form to populate a spreadsheet on Google Sheet. Here's what the data set might look like:
A data set listing out name, collected ...
-1
votes
1
answer
582
views
Excel: How to count how many times a consecutive text value appears
I'm making a work schedule and I have to pay attention to a specific rule that, no worker should be scheduled to work more than 6 days in a row.
I got this spreadsheet where I make those schedules but ...
-1
votes
3
answers
2k
views
Excel: How To Transpose Every Random amount of N Rows From One Column To Multiple Columns?
I have a set of multiple choices questions with ABCD as answers, all answers are stacked on a column, but not every question has the same amount of answers.
Instead of transposing every nth value, my ...
1
vote
1
answer
4k
views
Is there a formula for calculating the difference in minutes or hours between two times?
Is there a formula for Is there a formula for calculating the difference in minutes or hours between two times in two columns?
In my spreadsheet I have the following two columns called start time and ...
0
votes
1
answer
38
views
How to get Project Wise Summary numbers from one Google Sheet to another?
I am trying to create a Project accounting Google sheet.
In one sheet I have all the expenses, revenues for the projects. (see below)
and the other sheet will have list of projects with Summary of ...
0
votes
1
answer
309
views
Search across cells and return value from different cell
I need to reference a cell based on drop-down values from four different columns.
Essentially I am trying to compile a summary list of data from different tabs. Each tab is laid out the same however ...