D
Debossaurus
Hey guys - new to the forum here, I've always managed to search fo
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 blan
columns:
{=IF(COLUMNS($C96:C96)>COUNTA(8:8),"",INDEX(8:8,SMALL(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 threa
http://www.excelbanter.com/showthread.php?t=245285
and came up with the formula below as I assumed the "SMALL" portion o
the error was returning #NUM! but this hasn't worked. I'm not very goo
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!
Deb
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 blan
columns:
{=IF(COLUMNS($C96:C96)>COUNTA(8:8),"",INDEX(8:8,SMALL(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 threa
http://www.excelbanter.com/showthread.php?t=245285
and came up with the formula below as I assumed the "SMALL" portion o
the error was returning #NUM! but this hasn't worked. I'm not very goo
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!
Deb