ISBLANK /MATCH array formulas not working...

[BigDelGooner]

Hi all

I need a formula to check if there is any value in cells V8:Y8 (the values will either be blank or *

I have tried using both of these array formulas (with Ctrl,Shft,Rtn) but am not getting the answers I am after.

=ISBLANK(V8:Y8)
=MATCH("*",V8:Y8,0)

When using the ISBLANK function it says FALSE even when all cells are empty...and when using the MATCH function it returns 1 even when all cells are empty.

I think I know what the issue is...I just dont know the resolution. These formulas work when used on completely empty cells, however the cells I am trying to use these on where they dont work includes formulas. The cell values are blank, but the ISBLANK and MATCH formulas seem to be looking within the formula rather than the cell value.

 

[sheetspread]

"" is not blank, it's a zero length string or "invisible text"

Use an if = "" instead

 

[Jonmo1]

If the cells contain formulas, then they are NOT blank.
Even formulas returning "" are not really blank, that is a null text string..

Instead of testing for blank, test for NOT blank, and reverse the logic

=COUNTIF(V8:Y8,"<>")>0

That's basically counting cells that are NOT Equal to ""
And the >0 says IF the result of the countif is Greater than 0, then True, else False.

Hope that helps.

 

[BigDelGooner]

Excellent - thanks for your help.