Formula to fill the blank rows with the value above using a relative row id
I'm stuck with this formula I've found on this forum:
=INDEX(ITEM:ITEM; MATCH(MAX(COLLECT(ROWID:ROWID; ROWID:ROWID; @cell <= ROWID@row; ITEM:ITEM; @cell <> "")); ROWID:ROWID; 0))
This formula is used to fill empty cells with last non empty value from above. See my example below:
Since the formula is based on a autonumber column, I can't delete or insert a new row in the middle of the sheet. See line #6.
What I tried is to create an helper column called "row#" with a column formula: =MATCH(ROWID@row; ROWID:ROWID; 0)
to get the relative row position and use it instead of "rowid" but this method lags my sheet way too much.
My question is: Can someone help me to embed these formulas into one to use only the "ROWID" column?
Any help is welcome.
If anything is unclear, just tell me because english is not my first language.
Thank you community!
Help Article Resources
Check out the Formula Handbook template!