Auto Copy Formula????????

[Et3rnal]

I have a list of names from A1 to A10, and letters from B1 to B10.
These letters switch rows at random, but within my above range.
I need a formula that I could put in C1 that would look in the range B
to B10 for a selected letter, and copy a list out of A1 to A10 with th
names that corrispond with the selected letter.

IE

Names---------Letter---------Selected A

Name 1-----------A-------------Name 1
Name 2-----------B-------------Name 4
Name 3-----------C
Name 4-----------A
Name 5-----------B
Name 6-----------C



I am currently using a filter then copy/paste, but I would love it if
had a formula that did this on it's own, keeping in mind that th
letters will shuffle.

Any Ideas???

 

[Frank Kabel]

Hi
enter the following array formula (entered with CTRL+SHIFT+ENTER) in
C1:
=INDEX($A$1:$A$10,SMALL(IF($B$1:$B$1="A",ROW($B$1:$B$10)),ROW(1:1)))
and copy down