View Single Post
  #3   Report Post  
kamille824
 
Posts: n/a
Default

Thanks Biff, but I still have something wrong as I can't get the data to
fill is after 10:00 am. I have 286 rows of info and Columns thru "S"
The formula I used was:
=IF(ISERROR(SMALL(IF((Schedule!A$2:A$286=A$1)*(Sch edule!B$2:B$286=A$3)*(Schedule!C$2:S$286=A$2),Colu mn(A:Q)),ROW(1:1))),"",INDEX(Schedule!C$1:S$1,SMAL L(IF((Schedule!A$2:A$286=A$1)*(Schedule!B$2:B$286= A43)*(Schedule!C$2:S$286=A$2),Column(A:Q))),Row(1: 1))))

Can you see what I've done wrong?
Thanks for your help! I do appreciate it very much.
Kamille