Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Macro for getting the average of a number of cells

  • 27-05-2013 8: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 Posts: 3,498 ✭✭✭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