Results 1 to 8 of 8

Dynamic MOD & COLUMNS formula

Threaded View

dcwood57 Dynamic MOD & COLUMNS... 08-19-2019, 07:12 PM
protonLeah Re: Dynamic MOD & COLUMNS... 08-19-2019, 08:10 PM
dcwood57 Re: Dynamic MOD & COLUMNS... 08-19-2019, 08:37 PM
FDibbins Re: Dynamic MOD & COLUMNS... 08-19-2019, 08:44 PM
dcwood57 Re: Dynamic MOD & COLUMNS... 08-20-2019, 02:06 PM
protonLeah Re: Dynamic MOD & COLUMNS... 08-21-2019, 12:14 AM
dcwood57 Re: Dynamic MOD & COLUMNS... 08-21-2019, 09:51 AM
dcwood57 Re: Dynamic MOD & COLUMNS... 08-23-2019, 12:32 PM
  1. 08-19-2019, 08:37 PM #3
    dcwood57 is offline
    Registered User
    Join Date
    08-19-2019
    Location
    Clarksville, TN
    MS-Off Ver
    2010
    Posts
    5

    Re: Dynamic MOD & COLUMNS formula

    OK, an example of the formula is in cell F5 of the Analysis sheet.

    That particular cell is averaging data from three rows on the DataInput sheet.

    The input is done in the top half of DataInput sheet and consolidated in rows 40 - 55.
    Attached Files Attached Files
    Last edited by dcwood57; 08-19-2019 at 08:38 PM. Reason: rows not columns
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Dynamic Unique List from multiple dynamic columns
    By JO505 in forum Excel General
    Replies: 7
    Last Post: 06-11-2015, 05:41 PM
  2. [SOLVED] sum() and average() formula with dynamic columns
    By umbata in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-25-2015, 12:29 PM
  3. Summarizing multiple dynamic columns with a formula
    By YellowOnline in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-30-2015, 07:59 AM
  4. [SOLVED] dynamic index match formula to transpose values across rows and then down columns
    By Bananas212 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-30-2014, 03:07 PM
  5. Formula array summing a dynamic range of columns
    By UMBiii in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2014, 05:07 PM
  6. Help Need Formula Array to sum dynamic range of columns VBA Macro
    By UMBiii in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-04-2014, 08:05 PM
  7. Dynamic Count If Formula with additional columns and rows.
    By nwd9s in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2011, 09:12 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1