If Statements...
 

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.

If Statements...
 

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.

"Jamesy" wrote:

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.

If Statements...
 

On the button my friend!!

Thanks very much!

"Sivassou" wrote:

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.

"Jamesy" wrote:

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.