Looking for some help with duplicate data. I have data in a table wher
the values in column (B) may repeat. Column (B) is a job number.
Column (C) is the number of hours charged to that Job. If the Jo
takes more than 8 hours there will be two records. In some cases
there are several records (job takes 100 hours). I can sort the tabl
by column (B) so all like job numbers are next to one another. How t
I get excel to recognize the duplicates in column B and sum th
corresponding data in column (C). I want to see the total hours fo
each job number.

Thanks

--
VB12
-----------------------------------------------------------------------
VB123's Profile: http://www.excelforum.com/member.php...fo&userid=2816
View this thread: http://www.excelforum.com/showthread.php?threadid=47689