Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula errors | Excel Worksheet Functions | |||
Formula Errors / #Value! | Excel Worksheet Functions | |||
Formula Errors | Excel Programming | |||
VBA Formula Errors | Excel Programming | |||
Tricky array formula issue - Using array formula on one cell, then autofilling down a range | Excel Programming |