And what are you expecting the rest of sheet two to look like?

LOU wrote:
Good Day I have the following information and and am not sure wg=hich is the
best way to handle it.

Sheet1
Row ColumnA ColumnB ColumnC ColumnD
1 Date Audit Auditor Length
2 1/1/07 Butter Frank 1.5
3 1/1/07 Cheese Mary 2.8
4 1/1/07 Meat Perry 3.5
5 1/2/07 Butter Mary 1.5
3 1/2/07 Cheese Frank 2.8
4 1/2/07 Meat Perry 3.5
so on and so forth for the week.

I have on Sheet2 the schedule layed out like the following,

Row ColumnA ColumnB ColumnC ColumnD ColumnE
1 Frank Mary Perry TotalHours