| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find the first or last populated column in a range
I have a range of data, from columns C through Z.
And I have about 100 rows of financial data. The rows represent projects, and the columns represents periods where costs were incurred. So, some rows have data from C-Z, and others have data from H-M. How can I write a formula in column a1, to tell me which was the first column to have a value in row 1? And, likewise, I want to know which column has the last value. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to display last entry in a column populated with #N/As | Excel Worksheet Functions | |||
| Last populated cell in a column | Excel Discussion (Misc queries) | |||
| Last populated cell in a column | Excel Discussion (Misc queries) | |||
| LookUp to Display Last Value Populated a in Range | Excel Worksheet Functions | |||
| Referencing last populated cell in a column | Excel Worksheet Functions | |||
Threaded Mode
