Populate list from Data Matrix

[trench3368]

Dear All,

I hope you can help. I'm trying to get excel to generate a list of names (see attached spreadsheet - summary tab) from a matrix of data.

If anyone can help or point me in the right direction it would be greatly appreciated

Many thanks
Paul

[PaulM100]

This should do. Is array entered: Ctrl+Shift+Enter instead of Regular Enter:
=IFERROR(INDEX('Data Matrix'!$A$2:$A$9, SMALL(IF(ISNUMBER((SEARCH("X", 'Data Matrix'!$D$2:$N$9))*(SEARCH(Summary!$B$2, 'Data Matrix'!$D$1:$N$1))), ROW('Data Matrix'!$A$2:$A$9)-MIN(ROW('Data Matrix'!$A$2:$A$9))+1, ""), ROW(A1))),"")

Drag down as far as necessary

[trench3368]

Many thanks - that is excellent - if possible could you give a brief overview of how it works - many thanks again, Paul