Data Extraction - Criteria: Columns 1&2, Unique Data: Column 3 - to Matrix

[craigp]

Hi there,

I have been trying to work out how to do this for awhile without success...

Please see attached sample.

I have a list of data. The first two columns are the match/criteria. The third column is the unique data that I wish to extract. I want to extract this data to a matrix (column 1 match/criteria on the vertical axis, column 2 match/criteria on the horizontal axis).

Would really appreciate it if someone could clearly explain how to do this asap?

 

[craigp]

Here is a sample of the problem.

 

[NARAYANK991]

Hi Craig ,

See this file.

Narayan

 

[craigp]

Hi Narayan,

You actually are an Excel Ninja.

Thanks heaps, that works perfectly.

Now I need to spend sometime to actually make sense of it...

Much appreciated,
Craig

 

[craigp]

Hi,

How do I amend this formula to only extract unique values? (I.e. if there are duplicates in column K and I only want them displayed once).

Thanks,
Craig

 

[craigp]

For example, I have this formula:

{=IFERROR(INDEX(PS_Data_Source!$C$3:$C$6160,SMALL(IF(PS_Data_Source!$A$3:$A$6160=$C10,IF(PS_Data_Source!$B$3:$B$6160=D$8,ROW(PS_Data_Source!$C$3:$C$6160)-MIN(ROW(PS_Data_Source!$C$3:$C$6160))+1)),COUNTIFS($C$10:$C10,$C10))),"")}

which is great accept that it displays duplicate values that match the two criteria.