All Questions
Tagged with google-spreadsheets microsoft-excel-2010
14
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
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 (...
2
votes
1
answer
1k
views
CONCATENATE cells in a column IF condition in other colum is met
Using Google sheets (or Excel if Google sheets can't do it). I'm trying to concatenate any cell in B column, if its corresponding A cell is "include". The columns are very long and therefore ...
0
votes
1
answer
329
views
How to highlight down columns for many columns at once that are separated in an excel sheet?
I have 30 columns of data with over 10,000 rows. I'm using Ctrl+Click to highlight specific cells and then use Ctrl+Shift+Down arrow to highlight to the bottom, but I noticed it won't let me do that ...
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
...
-1
votes
1
answer
194
views
Separate text at variable words in Excel
I want to separate Text in a columns in two separate columns.
The columns should separated after following variable Performance,Learning & Growth and Business.
| AM ...
0
votes
1
answer
69
views
How to sort based on excel or sheets column data
I have a form that submits to a google sheet with the following columns:
Entry Date, First Name, Last Name, Address, Phone, Email, Member Type, Vote Date, Result
(The 'result' column has three ...
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'...
0
votes
2
answers
269
views
How to mark a row if any of the cells in that row is not empty
I want to set the value of a cell as "Y" if any of the cells in that row is not empty. I am using
=IF(COUNTA(INDIRECT("B"&ROW()&":"&"Z"&ROW())),"","Y")
in the column A. By using an ...
0
votes
1
answer
838
views
Aggregation of overlapping groupings in pivot table
I would like to aggregate a value of overlapping groups in a single pivot table.
An example of my data is:
Name, Value, Attribute 1, Attribute 2, Attribute 3
A, 1, True, True, True
B, 2, True, ...
0
votes
1
answer
945
views
Microsoft Excel: Merge two sheets and dedup
I have a pretty simple question and google can't seem to return what I'm looking for.
Essentially I have two sheets in one workbook, both contain the exact same columns. The primary key (and first ...
4
votes
2
answers
16k
views
How to create a data series for exponential decrease diagram
I want to create a pricing model this way:
If you need this product for 50 people, you should pay 2500 (units) per person.
.
.
.
.
If you need this product for 10,000 people, you should pay 300 (...
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 ...
1
vote
1
answer
716
views
Google Spreadsheet. Retrieve only one cell from ImportData-result [closed]
I have this function:
=ImportData("http://ichart.yahoo.com/table.csv?s=AAPL&a=0&b=7&c=2013&d=0&e=7&f=2013&g=d&ignore=.csv")
...which returns how a given stock was ...