excel macro help

Nottom · #1 02-12-2007, 04:19 PM

I don't have a lot of experience using macros, but I am trying to learn. Hopefully this will be pretty simple to those of you who use them regularly.

Essentially, I need to take a selection of data and then output a series of formulas based on them.

Assume that the data is currently selected.

I need (as an example)
A1 = Average(data)
A2 = Stdev(data)
A3 = Count(data)

Any help would be very appreciated.

udbrky · #2 02-12-2007, 06:01 PM

I'm not sure if I'm understanding what all you're trying to do.

But if this is what you're looking at:

data contained in cells b4:e10

You could type in A1:

=AVERAGE(b4:e10)

and A2:
=STDEV(b4:e10)

and A3:
=COUNT(b4:e10)

I think that would work.

Nottom · #3 02-12-2007, 06:34 PM

I was hoping to be able to use a macro to do it. Basically I want to be able to select a range of data, run a macro and then output a block of cells that perform different opperations on that data.

Certainly I could type out all the cells individually, but I'm hoping to find a way to automate it and save some time since I need to do this for a ton of different data sets.