Trying to remove blank cells from columns, problems with IFERROR formula.

If VBA is an option, you can take the below code and copy it into a module in your personal macro workbook. Then you can just select the columns and press ctrl+shift+R and all blank cells will be removed.

Please Login or Register  to view this content.

Originally Posted by Special-K

Use this instead, it may need tweaking, post your actual file if this doesnt work

=IFERROR(INDEX($C$2:$C$1000,SMALL(IF(($C$2:$C$1000<>""),ROW($A$1:$A$1000)),ROW(A1)),1),"")
Array formula, use Ctrl-Shift-Enter

Hmmm....your formula does the same thing. Must be something within my spreadsheet.

Here's my file & the sheet in question is "REF CALCS". My apologies, I attached the wrong file on my original post.

If you have a minute to take a quick look, I would be very appreciative.

There are error values within Column C, beginning at C531.

If I clear the contents from that row and down, then the formula works as expected.

Originally Posted by Jonmo1

There are error values within Column C, beginning at C531.

If I clear the contents from that row and down, then the formula works as expected.

Jonmo1, you are a genius....and I am a total tool!

I can't believe I didn't even take the time to check all the way down the range. My apologies for wasting you guys' time for such a stupid mistake......but many thanks nevertheless!

You're welcome.