To find column that is blank

[CassieL]

Hi everyone, Im working on a spreadsheet that contains many columns. I like to know if there is any function or ways to know the column no contains no value or blank cells. Please advice and thank you very much.

I tried using if and isblank funtion, but it does not seems to work.

[TABLE="width: 100"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I like to know which column contains no value, Ex: Column B, D & E are empty column.

Your help is much appreciated. THANKS

 

[dine]

Hi Cassie,

At the end of each column put CountA formula to see whether there is any value available at the column.

Ex: Enter the formula CountA(A1:A <lastrow)>) at end of Column A

Cheers!
Dine