Hi Team,
I am having trouble in understanding how to best write a formula for the use case i have:
1. Rows 2 & 3 are practically the same due to some upstream changes i made in my workflow
2. I require all the data in column E: AG to show zero with the exception of columns U;V;W;X [ HIGHLIGHTED IN YELLOW ATTACHED]
Thanks in adv
¡Resuelto! Ir a solución.
@suby nearly there but not quite what i was expecting. I have added a spreadsheet to show the expected result from the original. hope this clarifies?
@binuacs thanks mate - this worked and so sorry for the delayed response due to holidays!