| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| highest # in a column A & returns answer from column B Formula | Excel Discussion (Misc queries) | |||
| building list from a column of data | Excel Worksheet Functions | |||
| Formula to sum every 4th cell returns #DIV/0! error in some column | Excel Worksheet Functions | |||
| When building formula in excel, it would be very useful to have t. | Excel Programming | |||
| When building formula in excel, it would be very useful to have t. | Excel Programming | |||
Linear Mode
