Check if each column has at least one nummeric value

[rudfaden]

I have a range, and I would like ti check if each column is empty (has no nummeric values). I know that i can loop through all the cells in each column, but i wonder if there is a more efficient way?

 

[Glory]

I can't figure out a way to adapt this to incorporate an "If ... > 1" to give you a true or false answer if at least one numeric value is present. But it's a place to start.

=SUM(IF(ISNUMBER(A1:A10000)*ISNUMBER(A1:A10000),1,0))

Somebody else will have a better answer for you.

 

[asking]

What about just doing a count on the column, If there is a numeric value in the column it will count each numeric value as 1. E.G. ~ =COUNT(A:A) if there are no values ~ text only it will result in 0, if there is 1 value(number in the column) the count will show 1, if there is more than 1 value then it will till you how many there are.

In your example
=IF(COUNT(A1:A10000)=0,"No values", "Has values")

 

[Aladin Akyurek]

I have a range, and I would like ti check if each column is empty (has no nummeric values). I know that i can loop through all the cells in each column, but i wonder if there is a more efficient way?

Formulawise...

=ISNUMBER(MATCH(9.999999999999999E+307,A:A))

=COUNT(A:A)>0