| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find last column with data, but with headers and a total row
I have a spreadsheet with multiple months across the top, rows for data entry
and a total row at the bottom. There may be months with no data, followed by months with data. For example: 1/07 2/07 3/07 4/07 5/07 6/07 1 3 4 5 6 7 total 6 0 9 7 4 0 I need a formula or macro to find the last column with data and return the month from the column header (i.e. "5/07") Probably simple, but I can't figure it out. I'm using Excel 2003. -- CG |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total column changes colors when total equals sum of other columns | New Users to Excel | |||
| Excel - returning column headers in a seperate column | Excel Discussion (Misc queries) | |||
| find text in column h and total the corresponding numbers if colum | Excel Discussion (Misc queries) | |||
| total a colum using data from another column | Excel Worksheet Functions | |||
| Adding total dollars based on specific data from another column | Excel Discussion (Misc queries) | |||
Threaded Mode
