# Formula to evaluate criteria across two matrices

1. ## Formula to evaluate criteria across two matrices

Morning all,

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.

Snook

2. ## Re: Formula to evaluate criteria across two matrices

Give some examples . What is input . What is the expected result by formula.

3. ## 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. ## 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. ## 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.

6. ## Re: Formula to evaluate criteria across two matrices

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

7. ## Re: Formula to evaluate criteria across two matrices

Fantastic, I'll give it a whirl.

Once again, massive thanks kvsrinivasamurthy!

8. ## Re: Formula to evaluate criteria across two matrices

Welcome.

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

#### 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