+ Reply to Thread
Results 1 to 25 of 25

Help: Multiple criteria involving strings

Hybrid View

  1. #1
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Help: Multiple criteria involving strings

    I used Mmult() to avoid pressing Ctrl + shift + enter..

    Vikas Gautam

  2. #2
    Registered User
    Join Date
    08-11-2014
    Location
    COlogne, Germany
    MS-Off Ver
    2010, 2013
    Posts
    29

    Re: Help: Multiple criteria involving strings

    But the formula doesnt work when i put it in my original databse
    shows #value errror,
    I changed the column references to appropriate columns.
    What do you mean by avoid pressing control shift Enter? That is an illogical explanation. MMULT is array multiplication function.
    Anyway it is wrong, because it give 0 output when that is not the latest entry.

    Quote Originally Posted by Vikas_Gautam View Post
    I used Mmult() to avoid pressing Ctrl + shift + enter..

    Vikas Gautam
    Last edited by oasafox; 08-28-2014 at 05:28 AM.

+ 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] Complex IF function involving matching multiple criteria
    By adray13 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-25-2013, 03:05 PM
  2. Replies: 1
    Last Post: 12-20-2012, 04:18 PM
  3. Replies: 0
    Last Post: 09-29-2012, 12:27 AM
  4. Replies: 0
    Last Post: 04-18-2012, 06:51 AM
  5. [SOLVED] Counting multiple criteria involving dates
    By S Davis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-10-2006, 06:35 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