K
Kaygee
I have several thousand rows of customer information such
as AR info, time spent, # of people within the company,
etc. However, some companies appear more than once. I want
to merge the rows where the companies appear twice and add
up the columns where there is a number. Where there is
text, I don't care what happens to the text.
Example
Company Name Contract Time Spent # of people
AAAA New 300 10
AAAA Addendum 100 5
BBBB New 250 6
BBBB Addendum 120 3
I want two rows returned after using a macro or whatever
that have just the company names, either new or addendum
for Contract, 400 and 370 for time spent and 15 and 9 for
# of people.
as AR info, time spent, # of people within the company,
etc. However, some companies appear more than once. I want
to merge the rows where the companies appear twice and add
up the columns where there is a number. Where there is
text, I don't care what happens to the text.
Example
Company Name Contract Time Spent # of people
AAAA New 300 10
AAAA Addendum 100 5
BBBB New 250 6
BBBB Addendum 120 3
I want two rows returned after using a macro or whatever
that have just the company names, either new or addendum
for Contract, 400 and 370 for time spent and 15 and 9 for
# of people.