Apply formula cell by cell
Vito Piepoli
Forums
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?
Hi Vito, check out the fill
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.