Finding the first blank or zero value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Adding recognised Zeros 5
Average non-consecutive cells excluding zero 8
vlookup and match first value greater than 4
Blank Cells vs. Zero Values 2
First row where a cell is zero 1
Excel: Last non zero value in a row 4
formula finds values in apparently blank cells 1

Back
Top