Hello all,

I got help with an =IFERROR(INDEX formula but it is only bringing over every other cell in the INDEX.

I'm trying to create a list of states from another column - excluding blanks - there are blank cells (sometimes) before and after the data, depening on the result of an IF statment in another cell. The formula below is what I've written and then copied it down; however, like I said earlier the results only bring over everyother cell - please help:

CELL BO1
=IFERROR(INDEX(BN1:BN$2300,SMALL((IF(LEN(BN1:BN$2300),ROW(INDIRECT("1:"&ROWS(BO1:BO$2300))))),ROW(BO1)),1),"")
CELL BO2
=IFERROR(INDEX(BN2:BN$2300,SMALL((IF(LEN(BN2:BN$2300),ROW(INDIRECT("1:"&ROWS(BO2:BO$2300))))),ROW(BO2)),1),"")
CELL BO3
=IFERROR(INDEX(BN3:BN$2300,SMALL((IF(LEN(BN3:BN$2300),ROW(INDIRECT("1:"&ROWS(BO3:BO$2300))))),ROW(BO3)),1),"")

and so on.

The formulas above are all Array formulas.

I have to admit, I'm not really sure how to read the fomula above, I received help with this one.

Any help that you can offer, is greatly appreciated.