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

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
 
A

Aladin Akyurek

If the range of interest is of numeric type...

In A2 enter:

=MATCH(9.99999999999999E+307,1:1)
 
F

Frank Kabel

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

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

Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Index Match to ignore blank cells 0
row number of last non-blank cell 14
Reference to next non-blank cell 5
Return last non-blank cell in column 3
Count Number of Unique Cells That Don't Have Certain Characters 0
How to reference last non-blank cell value from a column cells? 2
Formula to return position of the next Non-blank cell in a column 14

Top