Originally Posted by
abrazee
I've tried this many ways and I can get it to return data, but only the smallest value. {=OFFSET(Cost!A1,SMALL(IF(Cost!J14:J18="MSC",ROW(Cost!J14:J18),""),1),0)}
The biggest reason is that I don't understand the SMALL function. Perhaps I should explain again - what I need to do is simply get rid of blank rows. The only problem is the rows with the data have an IF function and therefor arn't really empty.
I tried this:=IF(ROW()-ROW(NoBlanksRange)+1>ROWS(BlanksRange)-
COUNTBLANK(BlanksRange),"",INDIRECT(ADDRESS(SMALL(
(IF(BlanksRange<>"",ROW(BlanksRange),ROW()+ROWS(BlanksRange))),
ROW()-ROW(NoBlanksRange)+1),COLUMN(BlanksRange),4)))
Again, I got a blank for no return on the IF function.
Bookmarks