I am trying to standardise a file like this:
Blank.jpg
I need to all the cell filled for further grouping.
I have tried with this formula:
@IF(MAIN_AGGREGATION == "",@GetPreviousValue("MAIN_AGGREGATION"),MAIN_AGGREGATION)
Unfortunately it works for the first 2 rows only of Column AAA.
How I can get it work as if IDEA creates a virtual value to look up to give fill the blank cells?
Vito Piepoli
Offline
Last seen: 2 months 1 week ago
Joined: 08/15/2019 - 15:16
Hi Vito, check out the fill down script as it might do what you are looking for.
http://ideascripting.com/ideascript/fill-down-utility
Let me know if this meet your needs.
Hi Brian,
Thank you very much, it solved the issue.