Fill Range from array, filter then sort?

[jordiejones]

So a little background. my company spends about an hour each day (seven days a week) putting together an hourly floorchart to organize a staff of 20. not everyone works in a given day. I wish to exclude the following: BLANK,"req","off","pto","muh".

I have tried combining NOT(ISBLANK, COUNTIF, SMALL, and achieved limited results.
currently I have tried using the following

 =IF(ISERROR(INDEX(D:D,SMALL(INDEX(NOT(ISBLANK($D$2:$D$20))*ROW($D$2:$D$20),0),COUNTBLANK($D$2:$D$20)+ROW(D9)))),"",INDEX(D:D,SMALL(INDEX(NOT(ISBLANK($D$2:$D$20))*ROW($D$2:$D$20),0),COUNTBLANK($D$2:$D$20)+ROW(D9))))

which I found through searching but it does not do exactly what I am trying to do (I need to figure out how to add that to a vlookup?)

Any help even if direction to figure out how to ask the right questions would be greatly appreciated. I have posted a file showing what Im trying to do on my rapidshare:

http://rapidshare.com/files/452400003/example_of_pull_from_schedule.xlsx

 

[jordiejones]

Okay so an update on the question... I know what Im trying to do and here it is...
FIRST I want to LOOKUP a column of data based on date. VLOOKUP based on date cell (A1)?
THEN When it finds that column only list values that are NOT(OR(BLANK,"req","pto","muh","off")...basically anything that doesn't look like a work shift.
THEN SMALL? The values are shifts ie. 10-7, 12-8, 3-8, etc. SMALL only returns values that are numbers, so text like "10-7" won't show up before text like "10-3" unless I reference the column beside the shift time that would say hours worked and then longer shifts come in order before shorter shifts

That range of data should ONLY be the times of the people who work that day (and excluding any other text). This is Column B.

Column A should (I assume) lookup the values in column B and determine by the date, who these shifts are assigned to? Or in other words, Column A should be the names of the people who working next to their assigned shift.

Any help would be awesome. I've taught myself excel over the years using this message board and would love to figure out how to do this.

Thanks again!!!!
Jordan