I have the following table:
| ID | Month num | Year |
|---|---|---|
| 1 | 1 | 2024 |
| 1 | 1 | 2024 |
| 2 | 2 | 2024 |
| 1 | 2 | 2024 |
| 2 | 2 | 2024 |
| 2 | 2 | 2024 |
| 3 | 3 | 2024 |
I am looking to get the unique count of IDs when the month num is equal or lower to the respective month and the year is 2024.
The outcome would look like:
January 2024: 1 distinct ID
February 2024: 2 distinct ID (because it is counting unique ID for Jan and Feb)
March 2024: 3 distinct IDs (because it is counting unique ID for Jan, Feb and March)
And so on
I am trying different formulas but I am not able to get the desired outcome. I tried countifs and sumproduct but nothing… I am not sure what i am doing wrong and this seems like a pretty easy formula.
enter image description here
I am trying different formulas but I am not able to get the desired outcome. I tried countifs and sumproduct but nothing… I am not sure what i am doing wrong and this seems like a pretty easy formula.
Digital Aquarium is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.