Building Excel Formula that Returns the Column of Last Cell with Data

[[email protected]]

I'm hoping some of you can help me. Here's my problem. I have a row
filled with data. Is there a formula that will return the column of the
Last Cell within that row that contains data. So if the last cell to
contain is Cell Column E Row 1, it would return 5 since Column E is the
5th column.

I would like to accomplish this without VB coding if possible.

Thanks,

- Dave

[excelent]

works for row 10

A10=COUNTA(B10:IV10)+KOLUMN()


"[email protected]" skrev:

> I'm hoping some of you can help me. Here's my problem. I have a row
> filled with data. Is there a formula that will return the column of the
> Last Cell within that row that contains data. So if the last cell to
> contain is Cell Column E Row 1, it would return 5 since Column E is the
> 5th column.
>
> I would like to accomplish this without VB coding if possible.
>
> Thanks,
>
> - Dave
>
>