Finding the first blank or zero value
 

Hi
I am trying to find a way to locate which column the first blank or zero
value appears in my worksheet.
Eg.
1 2 3 4 5
10 11 13

The result should be column 4. I have tried to use lookup with isblank
together without success. Any help will be appreciated.
Thanks

This will find first blank cell

=MATCH(TRUE,A2:M2="",0)

enter with ctrl + shift & enter

--
Regards,

Peo Sjoblom

(No private emails please)


"AAMIFC" wrote in message
...
Hi
I am trying to find a way to locate which column the first blank or zero
value appears in my worksheet.
Eg.
1 2 3 4 5
10 11 13

The result should be column 4. I have tried to use lookup with isblank
together without success. Any help will be appreciated.
Thanks