Index Match Array or Similar required

[jthompson_25]

Dear all,

I have a data table of currency values, the top row contains all the currency pairings (GBP/EUR, EUR/USD etc). Whilst the columns on the LHS of the sheet contain information on the location and owner of the currency.

I am trying to write a formula capable of pulling out all the unique values in a row and transposing them into a list, once the list of numerical values is transposed I then wish to use these unique numerical values to pull out further information from my table.

So far I have tried {=INDEX(D5:T32,MATCH(0,COUNTIF($C$35:C35,D5:D32),0))} unfortunately this returns an N/A error I believe because my arrays are different sizes

In the image I am trying to pull out the orange figure and place it into the template (cells D38:39), once I have the orange figure in the template I can then use other formulas to pull values associated with this.

Thank you in advance for any help provided

 

[Fluff]

You're welcome & thanks for the feedback.

 

[jthompson_25]

Final question....I hope

I am trying to adapt the formula to pull the name of the person from column C (orange), unfortunately the formula returns the value Darren for everything.

Original Excel Formula:
=INDEX($D$2:$T$2,AGGREGATE(15,6,(COLUMN($D$2:$T$2)-COLUMN($D$2)+1)/($D$5:$T$32=E39),1))

Adapted Excel Formula (not working)
=INDEX($C$5:$C$32,AGGREGATE(15,6,(COLUMN($C$5:$C$32)-COLUMN($C$5)+1)/($D$5:$T$32=E39),1))

have tried removing absolute values from COLUMN($C$5) with no luck

 

[Fluff]

As this is now a significantly different question, it needs a new thread. Thanks