Cell -find number of columns unitl next non-blank cell.

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Hi,
I have a cell and need to know the number of columns over until the
next non blank cell.

Can this be done without a macro - match,offset,hlookup,etc.

Example.
Cell A1 =1,
Cell D1 =1
Cell A2 will contain answer: 3 (3 columns to the right)

Help.
Thank you.
-joe
 
If the range of interest is of numeric type...

In A2 enter:

=MATCH(9.99999999999999E+307,1:1)
 
Hi
in A2 enter the following array formula (entered with
CTRL+SHIFT+ENTER):
=MIN(IF(B1:IV1<>"",COLUMN(B1:IV1)))-1
 
Back
Top