Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Macro for getting the average of a number of cells

  • 27-05-2013 09:08PM
    #1
    El Siglo
    Registered Users, Registered Users 2 Posts: 3,803 ✭✭✭


    Hi folks,

    I'm in a bit of a spot. I'm after collecting really high resolution geochemistry from a geological core log and as a result I've a load of cells (30 X 22,201) and I want to get the average of a set number (i.e. the average of 34 row observations going down through the core log). Is there a macro or a way of writing a macro which calculates the mean going down through the data and outputs the data to a new cell (so the mean of 34 cells for each of the 30 variables?

    Any help would be much appreciated.


Comments

  • #2
    Lu Tze
    Registered Users, Registered Users 2, Paid Member Posts: 3,523 ✭✭✭Lu Tze


    El Siglo wrote: »
    Hi folks,

    I'm in a bit of a spot. I'm after collecting really high resolution geochemistry from a geological core log and as a result I've a load of cells (30 X 22,201) and I want to get the average of a set number (i.e. the average of 34 row observations going down through the core log). Is there a macro or a way of writing a macro which calculates the mean going down through the data and outputs the data to a new cell (so the mean of 34 cells for each of the 30 variables?

    Any help would be much appreciated.
    Not sure what you mean but i have used concatenate before to buidl awkward formulas where i couldnt just drag them down where i might be averaging 24 one hour values for days and days. I have attached a screenshot where you see the formula is built on the right hand side using the concatenate function on the other cells.

    Copying and pasting value of the cells with the formula leaves the formula just as text, and doing a find and rpelace on the equals sign will make the formula live.

    Im sure there is an easier way though!


Advertisement