All Questions
36
questions with no upvoted or accepted answers
1
vote
0
answers
65
views
Formula - Get previous date and sum of unique months based on unique user
Goal Estimate the next date Abbie will make the purchase based on average days.
Screenshot to give a better idea:
Questions
A.1 & A.2 - how to search for the most recent previous purchase date ...
1
vote
1
answer
392
views
Extracting text between two repeated sets of values in Excel
I have campaign names that conform to the following structure:
[Network] - [Language] - [Country] - [Channel] - [Campaign Type] - [Free Text]
This could look like:
Google - English - India - Display -...
1
vote
2
answers
228
views
Is it possible to reuse the same sumif range?
In the following table, I constantly reevaluate a2:a4 to run different calculations against it. In a real table it would have been thousands of rows like it.
Is there a way to somehow store a2:a4 in a ...
1
vote
0
answers
75
views
How could I create a filter custom formula that returns a match for cells CONTAINING a word/phrase OR another word/phrase?
I'd like to create a filter using a custom formula that will display only cells that contain the word "Red" or "Blue" (as an example) as part of a longer string. These words are mutually exclusive so ...
1
vote
1
answer
99
views
Formula Needed: How to calculate Time Escaped
We have an escape room business. We're trying to get a leaderboard setup but we can't seem to figure out how to set the times in excel. Can someone please help?
Format is (minutes:seconds)
A 35:06
...
0
votes
1
answer
609
views
Google Sheets - Making a chart where certain series do not have data for all X-axis values
I am making a chart for research in musicology which requires me to graph the duration and tempo of notes based on the score, i.e. musical values like a quarter note.
Using a recording of a string ...
0
votes
1
answer
38
views
How to get Project Wise Summary numbers from one Google Sheet to another?
I am trying to create a Project accounting Google sheet.
In one sheet I have all the expenses, revenues for the projects. (see below)
and the other sheet will have list of projects with Summary of ...
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
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
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
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
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 ...