Try this

Col A Id number
Col B Name
Col C Hours

Col D - cell D2 put this formula ( helping column )
=IF(A2<A3,A2,D1) and drag it down

Now Copy the Col A and Paste it in Col E

delete the blank cells - ( select the Range in Col E - Click F5 |
click special | choose blanks | ok | right click on col E | delete |
shift cells up | ok | esc

Now using Vlookup u can get the names in Col F =VLOOKUP(E2,$A$2:$B
$200,2,0)

Now in cell G2 put this forumla =INDEX($C$2:$C$200,MATCH(E2,$D$2:$D
$200,0)+COUNTIF($D$2:$D$200,E2),0)




On Nov 20, 9:14*pm, Aaron wrote:
Hi,

I need some help... Here is my data:
_____________________________________________
* * * A * * * * * * * B * * * * *C * * * * * * *D
1 *ID Number *Name * * * * * * *Hours
2 *10153 * * * * * *Joe * * * * 8
3 * * * * * * * * * * * 8
4 * * * * * * * * * * * 8
5 * * * * * * * Total * 24
6
7 *10219 * * * * * *Bob * * * * 5
8 * * * * * * * * * * * 5
9 * * * * * * * Total * 10
10
11 10569 * * * * * *Tim * * * * 10
12 * * * * * * * * * * *8
13 * * * * * * * * * * *8
14 * * * * * * * * * * *5
15 * * * * * * *Total * 31
___________________________________________

Basically, I want to copy the ID number, Name, and Total onto a separate
worksheet minimizing the need for manual data entry e.g.
10153 Joe 24
10569 Tim 31
etc.

Basically, I can copy the ID number onto the new worksheet and use a vlookup
to get the name. *But I'm having difficultly referencing the Total since it's
not on the name row as the ID and Name. *Any suggestions? *Thanks!