Hi Steve,

Am Thu, 28 Jan 2016 01:30:34 -0800 (PST) schrieb
:

If I wanted to take into account half-days (so in the example above D3/2) how would I do that? I've tried nesting an "OR" statement with the IF but don't get the correct result.

try:

=IFERROR(INDEX(C:C,SMALL(IF(($D$4:$D$34=7.5)+($D$4 :$D$34=3.75),ROW($4:$34)),ROW(A1))),"")
and enter with CTRL+Shift+Enter


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional