I have dynamic columns on every output.
In attached Sheet:
N2 = “Direct Total”, Q2 = “LC Total”, W2 =“M1 Total”.
I would like to add starting from B2…M2 = “Direct”
I would like to add starting from O2…P2 = “Lc”
I would like to add starting from R2…V2 = “M1”
On Every output “Direct Total”, “LC Total”,“M1 Total” position will change.
Output varies, sometimes i have “Direct Total” column only or "LC Total " or “M1 Total”.
Sometimes, i have combination of “Direct Total” column and “LC Total” and vice versa.
I mean all possible outcomes will be there for “Direct Total”, “LC Total”,“M1 Total”.
Please help.
Demo.xlsx (9.1 KB)