All Questions
105
questions
0
votes
1
answer
153
views
Excel/Sheets - Adding the content of a row to the end of another?
So I'm still new-ish to data analysis on Excel and/or Sheets, and I'm trying to "merge" data. Essentially, I have a few thousands rows, and I want every second row to be added to the first. ...
0
votes
1
answer
68
views
Populate names in cell based on tiered choices using excel formula
I have 2 tables
First table is a list of items and 3 other columns depicting choice tiers
Items Choice 1 Choice 2 Choice 3
item1
item2
item3
item4
...
0
votes
2
answers
41
views
Function that writes name depending on two conditions
I would like to know how to implement this in an excel formula: I have a column with some names, a row with different numbers (dates), and the remaining values work as "keys". For instance:
...
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 ...
0
votes
3
answers
1k
views
How to highlight a row if "yes" appears more than once across multiple columns
I have a product list export that shows the products and which categories those products are assigned to.
I want to audit the product list by highlight products that are assigned to multiple ...
0
votes
1
answer
53
views
Spreadsheet: How can I merge every nth line with a previous line?
I have a spreadsheet where each cell contains multiple key value pairs. Every value is on a new line. The content of every cell is the following: cell content I need to somehow merge the every second ...
0
votes
3
answers
7k
views
Excel formula to extract keys and values from a cell
In Excel I have repeated cells that contain the following set of key/values (this is a single cell with line breaks):
utmSource:Gmail;
utmMedium:email;
utmCampaign:Live;
utmTerm:software;
...
1
vote
1
answer
284
views
how to rearrange values in multiple cells in different columns in excel
I have a list of questions with 4 answer options for each question of them placed in 4 columns one next to the other, the correct answer option is ended with "!" which turn the cell to green ...
0
votes
0
answers
42
views
How can I add data in a sheet in one sheet and the entire row is added to others?
I'm actually trying to do the following:
1. Sort a sheet automatically when there is a new entry (which the script already achieves, script is shown below) lets call this Master sheet. The master ...
1
vote
1
answer
51
views
SUMIFS Using Multiple Ranges?
In the screenshot below, columns A-B are on one tab, D-F are on another, and finally H is on a tab of it's own. Columns A-B is a tab that I use to tally worked hours by each employee less any time ...
0
votes
1
answer
31
views
How to identify with a formula, multiple occurrences within a criteria for each row?
What is a good way to distinguish when there are duplicate entries given certain conditions.
Here is an example of the issue. The data exported (from Amazon Business) of orders creates multiple ...
0
votes
0
answers
145
views
Nesting multiple DATEDIFs in IF function?
Does anyone know how to nest multiple DATEDIFs in an IF function? I was able to get the result I wanted to achieve with one one date condition and return the value if it matched but I'm not able to ...
0
votes
1
answer
574
views
Google Sheets / Excel : Opportunity cost from a set of cash outflows
Suppose I have a set of cash outflows at the end of each year. I want to compute the cumulative opportunity cost of the cash outflows each year.
In the example above, suppose investments return 4% ...
0
votes
1
answer
855
views
How to sum values in a spreadsheet based on matching criteria in another sheet?
I have a spreadsheet where I track income and expenses. The spreadsheet has two different sheets which I am trying to craft a query between (example tables below).
Transactions:
Categories:
The ...
0
votes
1
answer
2k
views
check if any text within cell contains the text of any cells within a range
I'm looking for an Excel formula (which ideally also works within Google Sheets) that checks whether any part of the text value of a given cell contains the full text value of any previous cell within ...