V_c | year | c_c | mass |
M1 | 2020 | eu28 | 100 |
M1 | 2021 | eu28 | |
M1 | 2021 | uk | |
M1 | 2022 | uk | |
N1 | 2020 | eu28 | 90 |
N1 | 2021 | uk |
for the mass of M1, 2021,eu28 and next two rows needs to be assigned the values of 100. like wise N1, 2021, uk too need to have value 90.
how this is to be done? please help me out!
Solved! Go to Solution.
this is good.
There is a performance issue with multi formula tool.
Could you help in another way of resolving this issue please?
@vnktalteryx because the empty cells are referencing ones above them, it only strikes me to use the Multi-Row tool. This is using multiple tools though, so in all honesty, it might be worse in terms of performance. Worth a shot though!
I used @binuacs idea of a lookup table. Please credit him if it works.