Abstract summary data using formulae

[mdmackillop]

It's Poets Day thankfully, and after a long week, my brain needs a rest, so I'll invite someone better with formulae than I, to help with this little task.
Regards
MD

[Bob Phillips]

AS requested

[mdmackillop]

Magic!!!

[Shazam]

Here is another way of doing it.

Input cell I8 copy across to J8 and copy down.

=IF(ROWS($I$8:I8)<=COUNTIF($A$10:$A$27,$J$6),INDEX(B$10:B$27,SMALL(IF($A$10:$A$27=$J$6,ROW($A $10:$A$27)-ROW($A$10)+1),ROW(A1))),"")

must be confirmed with:

Ctrl+Shift+Enter

[peacenik]

Although I have used Excel extensively for years, I have never used Arrays. Can someone point me to a simple tutorial or give me some hints on how I can use them please.

[Bob Phillips]

You haven't lived! <g>

http://www.cpearson.com/excel/array.htm