Question Locked

Excel-Stopping and Starting an Average in a Column

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi! Thanks for taking the time to read my question. I have several columns of formulas where the results are random groups of numbers alternating with groups of blanks. The location and group size of the numbers varies. I would like Excel to do an average of each group of numbers. Can you please tell me what formula I could use to do that?
Thanks again for any help you can give me!

2 replies

by thumbsup2

Sorry, but Excel itself isn't capable of doing that.

You can use the average formula to average one group, then create another formula in another cell to average another group, and another one in a third cell to average a third group, etc... etc... etc...

But, there is no formula which is capable of averaging small groups and returning many different answers, one for each group.

Of course, you could learn VBScript. It can do it.

This discussion is closed to new replies.