MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How to get MIN, MAX and AVG of a variable sized table

  Asked By: Harry    Date: Oct 19    Category: MS Office    Views: 902

Can someone please help me?
I have a table where I need to get the Min, Max and Avg
of each column in the table. The problem is the table changes
size each time (more rows in next table, less columns in the next).
I can use a macro recorder if the table size is fixed. What is the
VBA command to use when the row and column varies? I also want
to put the Min, Max, Avg values of the column 2 cells below the last
row. Kindly help.



1 Answer Found

Answer #1    Answered By: Felicia Hill     Answered On: Oct 19

Sounds like a job for dynamic named ranges man... aka Ray Blake!!

Check out his web site at http://www.grbps.com

... and in particular http://www.grbps.com/articles.htm

Please get back to us if you still have problems.

Didn't find what you were looking for? Find more on How to get MIN, MAX and AVG of a variable sized table Or get search suggestion and latest updates.