All Questions
4
questions
4
votes
1
answer
166
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
392
views
Return text string for highest duplicate values
I've been battling with a google sheets conundrum so hoping someone can help.
In a nutshell, I'm trying to achieve the following based on the image below:
Where the name is the same in column C
...
0
votes
2
answers
999
views
Referencing an adjacent cell from a different sheet based on a minimum formula?
Basically, I have dates in A, and weights in B. On sheet 2, A1 I have =min(b) which give me the lowest weight in B.
On sheet2 b1 I want to reference the corresponding date for the minimum weight.
I'...
2
votes
2
answers
5k
views
Auto-fill rows from columns in another sheet?
I'm using Google Doc's Spreadsheet at the moment and I'm attempting to create the same view in another sheet.
First Sheet:
(yes I need these merged cells)
Second Sheet:
Unfortunately Google ...