| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find the first or last populated column in a range
"Commish" wrote in message
... 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. On May 13, 4:42 pm, "T. Valko" wrote: What type of data is in the cells? Text? Numbers? Both? Any formulas that return formula blanks? Exactly what result do you want? The column letter? -- Biff Microsoft Excel MVP Commish wrote: Biff, the data is either numeric, or empty. The column letter is fine, but ideally I'd want the value in a specific row on the answer column. Which row? |
| 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
