finding the maximum number of rows used in a range of columns

T

tmarsh

Hi All,

I have a table of data, but not all of the cells 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.

Thanks for any guidance,

Tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
finding the maximum number of used cells in any column of a table 6
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Varying cell ranges in formulas according to number of cells with certain value 1
Quickly count used rows? 5
Count Values in a Range, Not Formulas 2
Prompt For Replace in Selection And More... 0

Top