| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identify last non-empty column in a table
I have a table of monthly data for 2008. Monthly columns are empty until
month end data is available, except for the top row which contains the month names Jan thru Dec. How do I write a function to place the Excel Column Letter in a cell to identify the monthly column having the most recent data. If the top cell in a column is non-blank, then that column, and all before will complete. Hope this description is clear. Thx for your help, John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identify the row in which a MAX number in a column resides | Excel Worksheet Functions | |||
| looking for formula to identify next non-empty cell on another sheet | Excel Worksheet Functions | |||
| Need to identify duplicate entries in a Table | Excel Worksheet Functions | |||
| how do I identify the OLAP datasource of a pivot table | Excel Discussion (Misc queries) | |||
| Formula to Identify Column Number | Excel Discussion (Misc queries) | |||
Threaded Mode
