I am looking for a formula that would provide the following functions.

I have two colums of data, the first colum has internet addresses (Domain
names) and the second has the number of requests for this address (Hits).
First I need to sort the data by the first colum. Then need to add duplicate
entries in colum 2 (number of hits). This maybe 2 or 3 lines of duplicate
data in colum one and remove the duplicates leaving just one example with the
total next to it in colum 2. I have included a example below.

yahoo.com 24,349
yahoo.com 15,203
yahoo.com 20,584
us.army.mil 23,870
us.army.mil 43,090
us.army.mil 15,203



In a nutshell: Add the 3 like domains and remove 2 duplicates and leaving
one example with the sum total next to it and continue down the whole row of
data

This may seem remedial but I don't work with Excel very much. I appreciate
any help you can provide. Thanks!
--
Twilkin

Why not try a pivot table that will do it all for you.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Twilkin" wrote:

I am looking for a formula that would provide the following functions.

I have two colums of data, the first colum has internet addresses (Domain
names) and the second has the number of requests for this address (Hits).
First I need to sort the data by the first colum. Then need to add duplicate
entries in colum 2 (number of hits). This maybe 2 or 3 lines of duplicate
data in colum one and remove the duplicates leaving just one example with the
total next to it in colum 2. I have included a example below.

yahoo.com 24,349
yahoo.com 15,203
yahoo.com 20,584
us.army.mil 23,870
us.army.mil 43,090
us.army.mil 15,203



In a nutshell: Add the 3 like domains and remove 2 duplicates and leaving
one example with the sum total next to it and continue down the whole row of
data

This may seem remedial but I don't work with Excel very much. I appreciate
any help you can provide. Thanks!
--
Twilkin

Thanks Martin! Much appreciated!
--
Twilkin


"Martin Fishlock" wrote:

Why not try a pivot table that will do it all for you.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Twilkin" wrote:

I am looking for a formula that would provide the following functions.

I have two colums of data, the first colum has internet addresses (Domain
names) and the second has the number of requests for this address (Hits).
First I need to sort the data by the first colum. Then need to add duplicate
entries in colum 2 (number of hits). This maybe 2 or 3 lines of duplicate
data in colum one and remove the duplicates leaving just one example with the
total next to it in colum 2. I have included a example below.

yahoo.com 24,349
yahoo.com 15,203
yahoo.com 20,584
us.army.mil 23,870
us.army.mil 43,090
us.army.mil 15,203



In a nutshell: Add the 3 like domains and remove 2 duplicates and leaving
one example with the sum total next to it and continue down the whole row of
data

This may seem remedial but I don't work with Excel very much. I appreciate
any help you can provide. Thanks!
--
Twilkin