>> Exceeding the 30-argument limit <<
Excel has a 30-argument limit for statistical functions. It's easy to get around, though, if you group some of your arguments within parentheses.Instead of entering AVG(A1,A2,A3…,A33), you can enter AVG((A1,A2,A3)A4…,A33), and Excel will accept the grouped arguments as a single argument within the formula.
-----------------------------------------------------------------------
>> Ask Mr. Excel <<
Excel power users and support pros: Check out MrExcel.com. Mr. Excel answers one reader's question per week, according to what piques his interest, often including full macros to be copied and put to use.Because this is a side project for the site's operator, he can't answer every question submitted, but he has provided a message board for other Excel users to exchange information. Other site features include past week's tips, quick answers, book reviews, and the opportunity to find out whether you can answer the monthly challenge.
If you work extensively with Excel and Visual Basic, this may be the one resource you've been looking for.
http://www.mrexcel.com
No comments:
Post a Comment