Array formula - help with #NUM! errors
 

Hey guys - new to the forum here, I've always managed to search for answers and not have to post but this one got me stumped -

I have this array formula that works fine - it's used to remove my blank columns:

{=IF(COLUMNS($C96:C96)COUNTA(8:8),"",INDEX(8:8,SM ALL(IF($C8:$AD8<"",COLUMN($C8:$AD8)),COLUMNS($C96 :C96))))}

But I am getting #NUM! error returning when the results run out.
The table doesn't contain numbers.

I have tried to follow instructions in this thread http://www.excelbanter.com/showthread.php?t=245285

and came up with the formula below as I assumed the "SMALL" portion of the error was returning #NUM! but this hasn't worked. I'm not very good with the closed brackets, so that may have something to do with it?

=if(iserror(SMALL(IF($C7:$AD7<"",COLUMN($C7:$AD7) ))),"",IF(COLUMNS($C95:C95)COUNTA(7:7),"",INDEX(7 :7,SMALL(IF($C7:$AD7<"",COLUMN($C7:$AD7)),COLUMNS ($C95:C95))))

Thanks!
Debs