Formula to evaluate criteria across two matrices

[The_Snook]

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

[kvsrinivasamurthy]

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

[The_Snook]

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

[kvsrinivasamurthy]

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.

[The_Snook]

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.

[kvsrinivasamurthy]

In N4 then drag down.

Please Login or Register  to view this content.

[The_Snook]

Fantastic, I'll give it a whirl.

Once again, massive thanks kvsrinivasamurthy!

[kvsrinivasamurthy]

Welcome.
Pl mark the thread solved.