Auto Arrange / sort data

Hi

You on excel 2010 Aggregate will work!

AGGREGATE formula work from excel 2010-2013! Non-Array formula

INDEX, SMALL Work from excel 2003-2013 array formula

L11

Formula:

=IFERROR(INDEX(B$2:B$34,SMALL(IF(($B$2:$B$34=$L$8),ROW($B$2:$B$34)-MIN(ROW($B$2))+1),ROW(1:1))),"")

This is array formula! Press same time: Ctrl+Shift+Enter, NOT ENTER. Copy down and cross

See the file!

Regard