+ Reply to Thread
Results 1 to 8 of 8

Formula to evaluate criteria across two matrices

  1. #1
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    737

    Formula to evaluate criteria across two matrices

    Morning all,

    This is a follow up/new query in relation to this thread.

    I now have a formula that identifies which suppliers can undertake a requirement based on the criteria selected (Col L). What I would now like is an area that shows who the unsuccessful suppliers are and why they failed, i.e. how many criteria they didn't meet (Col N-P in yellow).

    I've updated the original workbook accordingly.

    If you have any questions or require further information just give me a shout.

    Thanks in advance,

    Snook
    Last edited by The_Snook; 08-28-2018 at 02:30 PM.

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    mysore
    MS-Off Ver
    Excel 2007
    Posts
    4,988

    Re: Formula to evaluate criteria across two matrices

    Give some examples . What is input . What is the expected result by formula.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  3. #3
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    737

    Re: Formula to evaluate criteria across two matrices

    Hi kvsrinivasamurthy,

    The inputs are selected in columns D&E (service required) and H&I (region required). A list is then generated in column L that identifies which suppliers can undertake the requirement in full. This is the solution that you previously provided to me.

    I've now been asked for a list of which suppliers cannot undertake the requirement (basically the flip side of column L) along with an analysis why, i.e. how many criteria they couldn't undertake.

    I've updated the attached document to show what the expected results would be based on the criteria selected (columns N-P in yellow).

    Hopefully this explains what I'm seeking to achieve. If you need any more information just give me a shout.

    Thanks for your assistance, much appreciated.

    Snook

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    mysore
    MS-Off Ver
    Excel 2007
    Posts
    4,988

    Re: Formula to evaluate criteria across two matrices

    ARRAY formula in O3
    Please Login or Register  to view this content.
    ARRAY formula in P3
    Please Login or Register  to view this content.
    Drag dwn both.

  5. #5
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    737

    Re: Formula to evaluate criteria across two matrices

    Thanks for this kvsrinivasamurthy, much appreciated.

    Apologies, I'm not sure I communicated this clearly but I also require a formula for column N to generate the list of suppliers that were unsuccessful, i.e. couldn't undertake all the criteria defined.
    Last edited by The_Snook; 08-30-2018 at 09:40 AM.

  6. #6
    Forum Expert
    Join Date
    07-20-2011
    Location
    mysore
    MS-Off Ver
    Excel 2007
    Posts
    4,988

    Re: Formula to evaluate criteria across two matrices

    In N4 then drag down.
    Please Login or Register  to view this content.

  7. #7
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    737

    Re: Formula to evaluate criteria across two matrices

    Fantastic, I'll give it a whirl.

    Once again, massive thanks kvsrinivasamurthy!

  8. #8
    Forum Expert
    Join Date
    07-20-2011
    Location
    mysore
    MS-Off Ver
    Excel 2007
    Posts
    4,988

    Re: Formula to evaluate criteria across two matrices

    Welcome.
    Pl mark the thread solved.

+ 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. Replies: 3
    Last Post: 11-27-2016, 09:35 PM
  2. [SOLVED] Formula to flag last three transactions for unqiue suppliers
    By Brawnystaff in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-23-2016, 05:37 PM
  3. Replies: 3
    Last Post: 06-14-2013, 12:55 PM
  4. [SOLVED] Formula to produce sequential number for multiple suppliers
    By tanyas in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2013, 05:55 PM
  5. Replies: 5
    Last Post: 09-02-2012, 04:34 PM
  6. [SOLVED] WHAT ARE REASONS THAT A FORMULA WILL NOT RESPOND TO PRECEDENTS?
    By Bizman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-30-2006, 03:00 PM
  7. [SOLVED] Excel Formula-different products from different suppliers.
    By Mangus Pyke in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 04: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