Delete blanks from Column

Hello all,

I've got a table of data on Sheet4. There is the occasional blank in Column P.

I want to be able to select Column P on Sheet4 and then copy this column to C2 in Sheet1, with the blanks being filtered out.

Is this possible?

It would appear that in my spreadsheet these cells are not actually blanks, as when I highlight a group of them it still counts them (i.e. I highlight 6 cells with nothing in them and it shows count as 6 in the corner).

It would help if you could supply a copy of your workbook.

I have attached a test workbook.

The majority of the data has been removed, so it does look quite bare.

The data I am having issue with is the column in Sheet4. There is one blank in there, which will not delete.

I am trying to get this column to copy from Sheet4 into Sheet1, with the blank being removed. But it appears that excel does not recognise this as a blank.

I will add that the range is dynamic, so at times there could be more or less values in that column on Sheet4.

This works for me

Please Login or Register  to view this content.

Wonderful, that works perfectly!

You're welcome & thanks for the feedback

How does it work? As the blank cells aren't actually blank in my spreadsheet.

The autofilter still sees them as blank, so I took the easiest option & used that.

Ok cool. I have a countifs formula on a worksheet that doesn't work because of the issue. It is supposed to count the blanks, but it doesn't because excel doesn't not recognise them as blank.

In that case how about

Please Login or Register  to view this content.