Hi,
This is for Google Sheets.
I need a formula that returns the text when using a sum max for a number by date.
In the below example, AA02 is the answer for January 2023 b/c 4,120 is the max sum (3,995 + 125).
This is for Google Sheets.
I need a formula that returns the text when using a sum max for a number by date.
In the below example, AA02 is the answer for January 2023 b/c 4,120 is the max sum (3,995 + 125).
cell A1 | 1/31/2023 | 2/28/2023 |
Result | AA02 | CCC |
data set | ||
Month Year | SKU | total |
1/31/2023 | AA02 | 3995 |
1/31/2023 | MCT06 | 100 |
1/31/2023 | AA02 | 125 |
1/31/2023 | MCT06 | 125 |
2/28/2023 | AAA | 100 |
2/28/2023 | AAA | 100 |
2/28/2023 | AAA | 100 |
2/28/2023 | BBB | 250 |
2/28/2023 | BBB | 250 |
2/28/2023 | CCC | 900 |