Apply formula cell by cell

3 posts / 0 new
Last post
Vito Piepoli
Offline
Joined: 08/15/2019 - 15:16
Apply formula cell by cell

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?
 

Images: 
Brian Element's picture
Brian Element
Online
Joined: 07/11/2012 - 19:57

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.

Vito Piepoli
Offline
Joined: 08/15/2019 - 15:16

Hi Brian,
Thank you very much, it solved the issue.