HI Gary's Student, I have ahd a quick look at the link.

I need the detail from across the other columns (to theleft) of what has
been placed in the last column based on the IF statement. So it seems to me
the array as it shifts the findings up to eliminate spaces would not work. Is
my assumption correct as I need the detail in the columns A - ..up to the IF
column?

Mike

"Gary''s Student" wrote:

Checkout:

http://www.cpearson.com/excel/noblanks.htm
--
Gary''s Student - gsnu200841


"MikeR-Oz" wrote:

HI,

I have applied a IF statement to Colun H with results in Column I, (thanks
to this group on showing me how) BUt now I would like to condense the
results in Column I to a seperate sheet all together without all the spaces
that are in the I after the IF statement was applied.

Thanks for the extra help.

Mike