Sum up values per unique filtered row (if GROUPBY function is not yet available)
0 A B C D E F 1 Data List Filter 2 date prod. val. 2022-12-31 3 2022-05-10 P1 15 4 2023-01-15 P1 18 5 2022-08-12 P2 30 6 2022-09-15 P3 50 Result 7 2023-06-15 P3 20 prod. val. 8 2023-06-18 P1 80 P1 15 9 2024-05-17 P4 25 P2 225 10 2023-08-19 P5 85 […]
Sum up values per unique filtered row (if GROUPBY function is not yet available)
0 A B C D E F 1 Data List Filter 2 date prod. val. 2022-12-31 3 2022-05-10 P1 15 4 2023-01-15 P1 18 5 2022-08-12 P2 30 6 2022-09-15 P3 50 Result 7 2023-06-15 P3 20 prod. val. 8 2023-06-18 P1 80 P1 15 9 2024-05-17 P4 25 P2 225 10 2023-08-19 P5 85 […]
Sum up values per unique filtered row (if GROUPBY function is not yet available)
0 A B C D E F 1 Data List Filter 2 date prod. val. 2022-12-31 3 2022-05-10 P1 15 4 2023-01-15 P1 18 5 2022-08-12 P2 30 6 2022-09-15 P3 50 Result 7 2023-06-15 P3 20 prod. val. 8 2023-06-18 P1 80 P1 15 9 2024-05-17 P4 25 P2 225 10 2023-08-19 P5 85 […]
Create a list based on multiple filter criteria without row limitation in COUNTIF formula
0 A B C D E F G H I 1 Data List Filter_01 Filter_02 Filter_03 2 date brand type prod. val. 2023-12-31 Br_B t1 3 2022-05-10 Br_A t1 P1 15 Br_C t2 4 2023-01-15 Br_A t1 P1 18 t3 5 2022-08-12 Br_B t2 P2 30 6 2022-09-15 Br_B t3 P3 50 Result 7 2023-06-15 […]
Rewrite Nested IF functions Excel
I have this formula, and I paste in cells, to give the concatenation of two cells values based on some conditions, it worked fine, until i had to increase the IF functions, and saw that there’s a limit.
Rewrite Nested IF functions Excel
I have this formula, and I paste in cells, to give the concatenation of two cells values based on some conditions, it worked fine, until i had to increase the IF functions, and saw that there’s a limit.
Conditional formatting formula based on value in other sheet
I use this formula in condition formatting to change the row color red based on matching value between 2 sheets in the same workbook =SUMPRODUCT((‘Stop Work’!$D$8:$D$500=$C10)*(‘Stop Work’!$K$8:$K$500=”Open”))
Conditional formatting formula based on value in other sheet
I use this formula in condition formatting to change the row color red based on matching value between 2 sheets in the same workbook =SUMPRODUCT((‘Stop Work’!$D$8:$D$500=$C10)*(‘Stop Work’!$K$8:$K$500=”Open”))
Conditional formatting formula based on value in other sheet
I use this formula in condition formatting to change the row color red based on matching value between 2 sheets in the same workbook =SUMPRODUCT((‘Stop Work’!$D$8:$D$500=$C10)*(‘Stop Work’!$K$8:$K$500=”Open”))
Using average, offset & match together
I’m creating a fitness tracker with daily inputs & a weekly summary on a dashboard. My daily input data looks like this: