I get an export out of our scheduling system and need to aggregate the raw materials needed. I need a formula that, when "1" or blank is shown, it will give the next value above that is not a "1" or blank
See below for my data set and what is needed
How my data exports Column I need to create with a formula
<tbody>
</tbody>
See below for my data set and what is needed
How my data exports Column I need to create with a formula
How my Data exports | Column I need to create with Formula |
A | A |
1 | A |
A | |
B | B |
1 | B |
B | |
C | C |
1 | C |
1 | C |
1 | C |
C | |
D | D |
1 | D |
1 | D |
1 | D |
D | |
E | E |
1 | E |
E |
<tbody>
</tbody>