if, sumproduct, help by date
 

Hello,

This first chart is where I am entering names by day (sheet one). Please
notice that not all fields are filled in (this will vary by day).

Name 1 Name 2 Name 3 Name 4
1/1/2006
1/2/2006
1/3/2006
1/4/2006
1/5/2006 Smith Jones Cooper
1/6/2006 Smith Jones
1/7/2006 Jones Cooper
1/8/2006
1/9/2006 Jones Cooper
1/10/2006
1/11/2006 Jones
1/12/2006 Smith Jones Cooper Smith
1/13/2006 Jones
1/14/2006 Cooper Smith
1/15/2006 Smith Jones Cooper Smith
1/16/2006

What I need help with is writing a formula that will bring the names from
sheet 1 into a table I will keep on sheet 2. The names need to come over by
weekending: for example in the chart below I need to have the names listed on
1/15 first, then the 14th, 13th and so on all the way to the 9th. There
could be as many as 20 names per day (line), and I also need help getting
past hte null cells. Sheet two will have a start and end date listed on the
page.

Week ending: January 15, 2006
Smith Jones Cooper
Smith Cooper Smith
Jones Smith Jones

Thanks