+ Reply to Thread
Results 1 to 2 of 2

Expanding array formula to include another column

  1. #1
    Registered User
    Join Date
    09-05-2019
    Location
    Glasgow, Scotland
    MS-Off Ver
    2013
    Posts
    25

    Expanding array formula to include another column

    Hello there,

    I have been using this formula to include data in my standard deviation calculation every 294th row:

    =STDEV.P(IF(ISNUMBER(I296:I766752), IF(MOD(ROW(I296:I766752)-ROW(I296), 294)=0, I296:I766752)))

    This works as hoped for. However, I now want to expand the range of inclusion by including Column G so that after the formula has finished with Column I it will then continue on with the same exact steps on Column G (Same starting row and end) Basically, just as if Column G's data was attached to the bottom of Column I in the first place. In case anyone wonders why I don't do that, my data combined hits the hard limit of Excel's rows.

    Thank you so much to anyone that can help me here. I have tried my hand at making it work to no avail.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Expanding array formula to include another column

    I think I'd go down the pragmatic route and add a helper column that adds G & I together and use that helper column in the formula.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Expanding the formula to include extra if statements
    By IanJS in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-09-2017, 10:34 AM
  2. [SOLVED] Macro to Insert column and include a VLOOKUP array for entire column
    By bdouglas1011 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2014, 06:28 PM
  3. [SOLVED] Array formula not expanding to match lines added to table
    By justmatt in forum Excel General
    Replies: 13
    Last Post: 05-03-2014, 02:16 PM
  4. [SOLVED] Expanding a formula to include multiple worksheets/tabs
    By Raidon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-12-2012, 12:46 PM
  5. Expanding IFCOUNT formula to include other variable
    By icets in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-26-2011, 11:36 AM
  6. Replies: 3
    Last Post: 06-14-2010, 08:22 PM
  7. [SOLVED] Need an Expanding array formula
    By havocdragon in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-05-2005, 06:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1