I´m building templates that then gets populated with data into tables. As the data quantity can vary plenty based on the occasion I want to have a flexible way to handle manipulation of the data. I could just add plenty of formulas, but it´s better if this adjusts dynamically. Both so no calculations are missed, but also so there are not useless formulas that still needs recalc.
Column OrderNo gets data from OrderData[OrderNo].
I want G3 to compare E3 and F3. This is all good.
But then I want G4 to compare G4 and F4. Current formula does not make that happen.
What is the most efficient way to handle this?
Screenshot 2024-04-29 at 10.18.06.png
SAMPLE FILE
Sample data.xlsx
Bookmarks