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

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

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

works for row 10

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


" 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