+ Reply to Thread
Results 1 to 1 of 1

Ignore empty data points when multiplying matrices with MMULT()

  1. #1
    Registered User
    Join Date
    01-30-2015
    Location
    Washington DC
    MS-Off Ver
    2010
    Posts
    37

    Ignore empty data points when multiplying matrices with MMULT()

    I am automating a template that can contain between 2 and 11 statistical data points and produces an X-Matrix (n x 4)....where 11>=n>=2.

    I then use =MMULT() to perform XT*X matrix multiplication which spits out a square matrix (3 x 3).

    I always have 11 data points, and use a form-control check box to toggle data points in and out of the analysis. Currently I use an IF statement to make the detoggled lines blank ("").


    1) Is there a way to get the MMULT() function to ignore the removed data points? In other words, I want MMULT() to look at an 11x4 array with 2 removed data points and understand that it is a 9x4 array (see pic).

    If this is not possible, I follow with two more questions:

    2) Is there an automated way to produce a nx4 array from a 11x4 array with blank lines (e.g. 11x4 to 9x4) WITHOUT using macros or VBA?
    3) Is there an automated way to change array ranges within a MMULT() function by referencing some logic?

    Thanks in advance!
    Chris
    Attached Images Attached Images

+ 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. Trace Empty Cells function points to a non-empty cell
    By dazimon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2018, 01:35 AM
  2. Replies: 29
    Last Post: 11-30-2017, 04:00 PM
  3. Replies: 3
    Last Post: 09-22-2015, 03:04 PM
  4. RAND cells but ignore empty cells with data at the top
    By muffybean in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2012, 03:31 PM
  5. Excel 2007 : Ignore empty cells? How?
    By PA0l0 in forum Excel General
    Replies: 3
    Last Post: 06-02-2011, 07:29 PM
  6. Charting: How to Ignore Data points With Errors
    By mickeypikey in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-11-2011, 09:10 AM
  7. ignore empty data across a range
    By ruberg in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-23-2009, 12:56 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1