Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding the maximum number of used cells in any column of a table
[sorry if this appears cross-posted... the original is in
microsoft.public.excel.worksheetfunctions but that seems like a 'dead' group] Hi All, I have a table of data, but not all of the cells in each column will be filled. i am trying to find a worksheet function that will return the maximum number of rows filled by any of the coumns in the range. the result will go on another sheet in the same workbook (ie, this is where the excel function will be). I can do it by using: - =max(counta(A:A), counta(B:B), counta(C:C)) etc etc, but in one case i have 41 columns (!) so i was wondering if there is an easier way... i thought i might be able to use an array formula but so far that has been unsuccessful. i know i could do it with VBA but i am trying to avoid this route at the moment. to clarify: the final answer will be a single cell indicating the maximum number of cells filled in any one column (i don't need to know which column) Thanks for any guidance, Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Number of cells in a column of other sheet having a specific word in them | New Users to Excel | |||
Finding row & column given value in a Table | Excel Worksheet Functions | |||
Finding the closest number in column A and take the value in column B | Excel Worksheet Functions | |||
Finding a maximum number...with an exception | Excel Discussion (Misc queries) | |||
Finding a number in a table? | Excel Discussion (Misc queries) |