All Questions
105
questions
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 ...
0
votes
1
answer
35
views
Excel/Google Sheets: What is the best way to continue this formula so it will include cells yet to be filled in?
I'm manually calculating the variance and standard deviation of a set of potential investment returns, each with their own probability of occurrence.
Assuming I'd like to expand this list and not have ...
0
votes
2
answers
141
views
How to get "winner" based on row MAX
I'm trying to get the header value based on the highest value per row.
For example, given a sheet like:
A B C D
-------
1 2 3 4
3 3 1 2
I'd like to do reports on the winners of the row. For example ...
0
votes
1
answer
163
views
How do i create a Dynamic Dropdown Data Validation List based on pre selected criteria?
I seldom use Google Sheets or Excel, but now that I'm working on a card game, I have since thrusted myself into formulas and data validation.
I'm currently running into a logic issue.
I would like to ...
0
votes
1
answer
26
views
Time since previous order
I need to go through a big amount of data for the last 2 years in a company and calculated the time since previous orders for Users who have made multiple purchases. Which Excel function can be used ...
0
votes
1
answer
46
views
Return X amount(s) of cell values under under specific cell address
To start, thanks for reading, I will be leaving this picture here, which is what my current sheet looks like.
I'm trying to parse the information on A:A so that every instance of "X/Y", ...
0
votes
1
answer
36
views
Excel/GoogleSheets Forumla to List All Rows Without A Corresponding Value in Another Column
I'm hoping there is a simple way to perform the following. I have 2 columns (A,B), and I would like a third column (C) which consists of all values from column A that have an empty cell in column B. I ...
0
votes
1
answer
750
views
Formula to identify a list of codes in various combinations
Bit of a tough one to explain, but here we go... I have a large database (15K rows) of unique codes (AA1, AA2, AB1, etc.) in letter & numbers convention that identify them to a specific name (in ...
0
votes
1
answer
739
views
Count cells in a column between values until specific value reached in Google Sheets - Multiple Criteria
I am trying to do a tricky conditional count on a dataset. I need to count the number of rows that meet a set of criteria (after a specific date, a certain category) that sums up to a set limit - that ...
0
votes
2
answers
222
views
Perform multiple calculations in one cell
I have a spreadsheet that has 4 columns that perform a simple "if" based on some data entered elsewhere. Adjacent to each of those columns is another column that assigns a "1" or &...
0
votes
1
answer
213
views
In Excel I am wondering how if a value is met in a column then to sum up the cell to the left of that value across multiple rows if that makes sense
For example where the cell says David I want to sum all the cells on the left of David in £ up to a total like at the bottom not sure how I'd go about this.
£4500 IWI 14/12 DAVID
...
0
votes
2
answers
453
views
Extracting multiple values from a sentence in single cell with same preceding value. eg. Player 1, Player 2
Im trying to extract just the Player numbers from the sheet below.
What is the best way to extract just "Player + (player number)" ?
0
votes
1
answer
24
views
Need help in Excel Adding 2 columns
i just want to add column 2 to column 1 if and only if column 2 has just 1 text character in its cell .enter image description here
0
votes
1
answer
59
views
How to FIlter/Match spreadsheet data based on two row headers?
I need to find a value based on a specific column and header, that also fall within another merged header (spans 3 cells) like the example below:
|January 2020 |February 2020 |...
0
votes
1
answer
154
views
How can you format each row from a pivot table to display transposed with the headers repeating themselves?
From a pivot table, I am attempting to take each row of data and format it transposed with the headers from the pivot table present in each instance. Here is a link to a Google Sheet that has a sample ...