Macro to auto-populate cells based on content of other cells

Hi,

It doesn't need a macro.

The simple function

Formula:

Please Login or Register  to view this content.

in B3 copied down will do.

Thanks, this is very helpful and deals with the question as expressed.

Unfortunately I didn't give the full question (to keep things simple). The actual spreadsheets I'm looking at are a bit more complex. They aren't just using the 'average' function but, in some cases, are producing a weighted geometric mean. This involves an addition column setting out the weights.

I've attached a different 'Before' and 'After' spreadsheet. It would be lovely if this could be done with something like AVERAGEIF but maybe this one does need a macro?

Thanks for the help/ quick responses.

Hi,

It's important when you put your question that your example data represents your real life data otherwise we all waste a lot of time.
In this case I have no idea how you've calculated your results. They don't appear to accord with any weighted geometrically or even arithmetic mean that I can see.

Explain your workings.