Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I was surprised to find three or four code samples that did a similar thing as below, but was unable to adapt the monsters to my sheet. Here is what I want to do. With columns A & B: Change this GL14 x GL15 GL15 GL15 GL16 x GL17 GL17 to this GL14 x GL15 3 GL16 x GL17 2 Whe if there is text in column B leave A and B as is. Whe there were three GL15's before, reduce to one GL15 with a count of how may there was to begin with. The codes I could find were pretty much multiple employee ID numbers in A and hours worked in B, then add all the hours for same ID and return a single ID in A and the total hours for that ID in B. Thanks. Howard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count duplicates | Excel Programming | |||
Count Duplicates | Excel Discussion (Misc queries) | |||
Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
Reduce columns and rows count? | Excel Worksheet Functions | |||
count a group of numbers but do not count duplicates | Excel Worksheet Functions |