help with writing IF formula

I swung your table around, you are likely to have faer more dates than names, and its always better to have dates go downwards....

	B	C	D	E	F
11	PAUL	JOHN	SIMON	MIKE	PATTY
12	1/17/2015		1/5/2015		1/7/2015
13	1/18/2015		1/13/2015		1/8/2015
14	1/19/2015		1/22/2015		1/13/2015
15	1/20/2015		1/28/2015		1/14/2015
16					1/16/2015
17					1/21/2015
18					1/22/2015
19					1/29/2015
20					1/30/2015

B12=IFERROR(INDEX(Sheet1!$A$4:$A$33,SMALL(IF(Sheet1!B$4:B$33="H",ROW(Sheet1!$A$4:$A$33)-3),ROWS($A$1:$A1))),"")
ARRAY entered, then copied down and across.
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Hi mdot,

I've also moved your data around in 2 different sheets and done Pivot Tables on them. This is just to let you see other ways to see your data. See if these are better than what you now have.

I kept your existing format. But you will see it complicates the formula.

You need a different formula for each staff member.

Formula:

Please Login or Register  to view this content.

not quite true one way keeping original layout
=IFERROR(SMALL(IF(INDEX(Sheet1!$B$4:$F$34,0,MATCH($A5,Sheet1!$B$3:$F$3,0))="h",Sheet1!$A$4:$A$34,""),B$4),"") array entered
in b5 then filled across and down