Hans, it doesn't seem to work. I just keep gettin 0. What I want is the last
used column to the right of column G - column G. The formula is entered in
column F. There are blank cells to the left of column F. I'm not sure if this
is effecting the results. Thanks for your efforts.



"Hans Knudsen" wrote:

Try this array formula:
=MAX((5:5<"")*COLUMN(5:5))-COLUMN($G$5)

Hans



"NDBC" wrote in message
...
I have a row of data that may have some blank cells in it. Is there a way
to
count the number of cells (including blanks) between say G5 and the
rightmost
cell with data in it using spreadsheet formulas, not vba code.

Thanks