If Statements...

J

Jamesy

Hi Guys,

Just a quick one, is there a simple IF formula for the following...

A B C D
E
1 ZZ II BB
2 AA
3
4 PP
OO

What I require is a formula that highlights a blank row, so row 3 would be
the correct answer here.

Again you help/suggestions are much appreciated!

Regards,
James.
 
S

Sivassou

Hi Jamesh,

Use Counta(Range) formula. Zero will be answer for Blank row.

Here you can use counta(a1...f5), and you will get zero for counta(a3....f3)=0

Good Luck,
Sivassou.
 
J

Jamesy

On the button my friend!!

Thanks very much!

Sivassou said:
Hi Jamesh,

Use Counta(Range) formula. Zero will be answer for Blank row.

Here you can use counta(a1...f5), and you will get zero for counta(a3....f3)=0

Good Luck,
Sivassou.
Click to expand...
 
Top