Extract Unique Values Matching Two Criteria

[craigp]

Hello,

I am trying to extract unique values that match two criteria (and display them in a matrix).

I already have a formula that extracts values that match two criteria (and displays them in a matrix). HoweverI need to modify it so that it only extracts (and displays) unique values.

Please see attached.

I would really appreciate some help.

Thanks,
Craig

 

[azumi]

Hope this helps...........

 

[craigp]

Hi Azumi,

Thanks for your response. That's a seriously impressive looking array formula. Unfortunately I am wanting to extract/display data the other way round.

I want to extract/display the data from the table (column K by matching to columns I and J) and display it on the matrix (columns A to G by matching to columns B and row 4).

Any ideas?

Thanks,
Craig

 

[azumi]

Ooops sorry misread your requirement, fix it now, using array formula.....

 

[craigp]

Hi Azumi, I think you've attached the same file

 

[azumi]

Lol always make a mistake, that what I am