All Questions
105
questions
0
votes
0
answers
246
views
How to bring sum of previous column in to next column automatically, in Excel or Google Sheets?
I'm new to this. I'm trying to make a personal budget sheet, where I can bring the previous months' sum into the next month's column as "savings from last month". Basically I want to show ...
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 ...
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 ...
1
vote
1
answer
47
views
Excel/Sheets: Average only the input data in a range of data?
I've got an annual budgeting spreadsheet in which each month is listed along with given categories of items. I'm trying to find my average monthly expenditure on any given category, but don't know the ...
0
votes
0
answers
22
views
Listing function points in a spreadsheet/excel [duplicate]
I am working on a Pre-Calculus Polar coordinate graphing project that incorporates some creativity; My current plan has me graphing the Nautilus Shell as my focal point.
However, I have to list points ...
0
votes
0
answers
805
views
How to apply Text cell format permanently on a google sheet's column?
I recently added IDs as Number in a column those are basically built as alphanumeric.
Then I've applied Text cell format on those IDs to keep their data consistent with the other cells in that column, ...
1
vote
1
answer
449
views
How to copy rows of specific columns based on a criteria (and then continuously update)?
I have 2 sheets, let's call them sheet 1 and sheet 2.
In sheet 1, I have some data where essentially at its core its a Scoring tally, something like this:
Name
Age
Gender
Score
Jack
12
Male
155
...
1
vote
1
answer
286
views
How to calculate max sum held over a month?
I need help with a formula that needs to calculate the max sum held at one time for each month.
In this example it would be 54 for March (12+13+14+15, held on the 29/03/2021). Month is determined by &...
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 -...
0
votes
1
answer
127
views
How can you show the first cell in a cluster in Excel? And how can you lookup the value?
Several questions. But let me break down the problem of what I am trying to do:
I have a condition to show YES/NO if a certain value is met. If YES >= 60 and NO <=30 - this is easy I can do ...
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 ...
0
votes
3
answers
148
views
Sum of vlookups for each value in a row
There should be a way to do this, and yet I'm struggling...
==The Data==
Sheet1
A B
+---------------+-------+
| Fishy_Product | Price |
+---------------+-------+
| Cod | $9....
0
votes
1
answer
476
views
Can I make a graph for iterative function in MS Excel or Google Spreadsheets?
Let's say I have a formula:
k = 0.2
a = pow(a, k)
I'd like to see how the curve changes on each iteration with a different k value. The formula can be anything. The only thing is - I need the ...
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?
0
votes
2
answers
404
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
...