| Book4 | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | Product Code | Fiscal Year Quarter | unique Quarter the product has been sold | Column1 | ||
| 2 | A | 2025 Q2 | 7 | 7 | ||
| 3 | B | 2025 Q2 | 8 | 7 | ||
| 4 | C | 2025 Q2 | 7 | 7 | ||
| 5 | A | 2025 Q1 | 7 | 7 | ||
| 6 | B | 2025 Q1 | 8 | 7 | ||
| 7 | C | 2024 Q1 | 7 | 6 | ||
| 8 | B | 2024 Q1 | 8 | 7 | ||
| 9 | C | 2023 Q1 | 7 | 7 | ||
| 10 | A | 2023 Q1 | 7 | 7 | ||
| 11 | B | 2024 Q2 | 8 | 7 | ||
| 12 | C | 2024 Q2 | 7 | 7 | ||
| 13 | A | 2023 Q2 | 7 | 7 | ||
| 14 | C | 2023 Q2 | 7 | 7 | ||
| 15 | B | 2024 Q3 | 8 | 7 | ||
| 16 | A | 2024 Q3 | 7 | 7 | ||
| 17 | C | 2023 Q3 | 7 | 7 | ||
| 18 | B | 2023 Q3 | 8 | 7 | ||
| 19 | A | 2024 Q4 | 7 | 6 | ||
| 20 | A | 2024 Q4 | 7 | 6 | ||
| 21 | C | 2023 Q4 | 7 | 7 | ||
| 22 | B | 2023 Q4 | 8 | 7 | ||
| 23 | A | 2024 Q1 | 7 | 7 | ||
| 24 | C | 2024 Q1 | 7 | 6 | ||
| 25 | B | 2023 Q1 | 8 | 7 | ||
| 26 | Correct but slow! | Incorrect but fast! | ||||
Sheet1 | ||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| C2:C25 | C2 | =COUNTA(UNIQUE(IF([Product Code]=[@[Product Code]],[Fiscal Year Quarter],"")))-1 |
| D2:D25 | D2 | =COUNTIFS([Product Code],[@[Product Code]],[Fiscal Year Quarter],"<>"&[@[Fiscal Year Quarter]]) |
