Hello, I am really struggling with finding the right Excel formula for my task and and wanted to reach out for some ideas.
Essentially I want to do this:
You have 2 columns, A and B.
Column A is days of the month and column B is values
So column A would look like:
1/1/10
1/2/10
1/3/10
1/4/10
1/5/10
1/6/10
1/7/10
etc.
Column B would just be corresponding values:
3
4
5
8
4
9
2
etc.
What I want to do is: for every week, count the number of rows there are until you hit a specific limit. Lets say this threshold is >= 8. So I would want to count all the rows before we get to a value that is >=8, and then for that week, everything after that first occurrence of a value >= 8, is not counted. So for this example, we have one week. The first occurrence of a value >= 8 is on 1/4/10. So the number I want would be 3, because there are three days before we hit a value >= 8. Everything after that first occurrence of a value >= 8 I do not want counted. So for this week, my desired return value would be 3. Now the tricky part... I want to do this going down this list of daily dates and find the desired return value for each weak.
For example, this is what I want:
Week 1: 3
Week 2: 4
Week 3: 2
Week 4: 3
etc.
Of course all of these values would be
Dear Lino,
Find attached file should helps in your calculations,
Best regards,
Tomasz
Hi Dear Lino,
This page can help you.
https://stackoverflow.com/questions/45307510/sum-values-based-on-first-occurrence-of-other-column-using-excel-formula
Dear Lino,
Can you make one excel sheet and the write what do you want. Then it will be easier to understand .
- Badges
- Science topic
- Similar topics
- Analytical Chemistry
- Column