Arrange an array based on another array

andy

Alright, in column A, I have 60 "Group Numbers", each of which is an integer 1-8.

In column B, I have a list of 60 names.

I'd like to create a table that shows every name that is in each particular group.  Similar to a pivottable, but with text entries...

Any help??

Consider A2:I10...
Size231211DanGroup123452KarlDanKarlDamonJonJohn1MonicaMonicaBrianHenk3DamonScarlett2Brian4Jon2Scarlett5John4Henk
E1, copy across:
=COUNTIF($A$2A$10,E2)
E3:
Control+shift+enter, not just enter...

Code:
=IF(ROWS(E$3:E3)
...then copy across and down.

Originally Posted by mhenkAlright, in column A, I have 60 "Group Numbers", each of which is an integer 1-8.
In column B, I have a list of 60 names.
I'd like to create a table that shows every name that is in each particular group. Similar to a pivottable, but with text entries...
Any help??