I have set up the following function:
{=INDEX(K514:K522, MATCH(TRUE, K514:K522="",0)-2)}
This is the range K514:K522 for clarity.
Salaries and benefits
Subcontractors
Utilities & Property Tax
Repair and maintenance
Bank charges and interest
(Blank)
(Blank)
(Blank)
This looks through the array K514:K522 for the first empty cell then returns the item 2 rows before it. I have created an array of 8 of this formula moving down, so the -2 returns repair and maintenance, the -3 returns utilities and property tax, etc. Where I run into an issue is with -5, which returns Salaries and Benefits as intended but -6 also returns Salaries and Benefits. -7 returns a #VALUE error. I am unsure of what is causing this replication.
Bookmarks