| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
duplicate data, if command in VBA
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Command Button to make multiple duplicate worksheets | Excel Worksheet Functions | |||
| identify duplicate data upon entry of that data | Excel Discussion (Misc queries) | |||
| comparing lists of data to remove duplicate data | Excel Discussion (Misc queries) | |||
| how can i locate duplicate data in an excel data table? | Excel Worksheet Functions | |||
| Scanning for Duplicate Data in a Column, Merging Data and Finally Removing All Duplicates...? | Excel Programming | |||
Threaded Mode
