All Questions
105
questions
13
votes
3
answers
25k
views
How do I append a character to the end of every line in an Excel cell?
I have a column of Excel cells that's similar to a grocery shopping list and looks as follows:
3 Days Ingredients
2 Apples
1 Jug of milk
3 Bags of mixed vegetables
5 Potatoes
Is there a way to ...
- 241
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 ...
- 225
5
votes
2
answers
199
views
Determine United Airlines status level using worksheet functions
United Airlines MileagePlus Premier status levels are determined by a combination of criteria:
Silver: (PQM>=25000 OR PQS>=30) AND PQD>=3000
Gold: (PQM>=50000 OR PQS>=60) AND PQD>=...
- 53
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, ...
3
votes
2
answers
87
views
I want to count IF both condition are true Logically count by AND excel
I have two Columns both are categorical columns. Like Age_group and Engagement_category.
And I want to get count no. of each engagement_category in each Age_group.
| Engagement_category | Age_group |
...
- 171
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 ...
- 25
2
votes
1
answer
63
views
I want to make new column with Logic?
Given: Employee ID and Manager ID.
| Employee ID | Manager ID |
|:-----------:|:----------:|
| E068 | E067 |
| E071 | E067 |
| E229 | E069 |
| E248 | ...
- 171
2
votes
2
answers
81
views
Enter the no.s from two columns and the numbers in between to a 3rd column
Currently, I am having a table structure as below:
I tried selecting two columns with the series and dragging it down for autofill but didn't seem to work. I need something like below. Is there any ...
- 156
2
votes
1
answer
8k
views
Excel : VLOOKUP returns the last value in the column
I've got a problem with the vlookup() function. I search a text in a table (A column) and want to return the E-column value (E10). However, vlookup() returns the last value of the column (E35). I ...
- 23
2
votes
3
answers
6k
views
Combine multiple email addresses (in separate cells) into one cell (separated by comma) Google Sheets or Excel
I'm trying to combine multiple cells with email addresses into one cell where emails are separated by commas.
I've used this formula:
=P2 & ", " & Q2 & ", " & R2 & ", " & AD2 ...
- 23
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 ...
- 595
2
votes
1
answer
534
views
Update an excel list dynamically without using scripts
I'm a bit stuck and could use some help.
I am trying to keep a list in excel updated dynamically, based on conditions in other cells. Something along the lines of (IF both cell values in A1 and A2 ...
- 25
1
vote
2
answers
132
views
Advanced F&R Regex - Sheets / Excel - If "X" is in cell A1 and add "Y" to cell B1
I am looking for a formula or regex that I can use to find a value in a string in one cell and if found add another string to the adjacent cell in another column.
For example, I have a list of ...
1
vote
2
answers
28
views
Sequence Generation formula in excel for an “exploder” function
I am wondering if there is a way to create the following type of sequence in excel:
1 1
2 1
2 2
3 1
3 2
3 3
4 1
4 2
4 3
4 4
5 1
5 2
5 3
5 4
5 5
I would ...
- 13
1
vote
1
answer
15k
views
google sheet formula, if “yes”, copy to other sheet
I’m trying to figure out the formula in google sheets - if the cell is “yes”, then copy the adjacent cell to another sheet. Can anyone help?
- 13