Hi all.

Im a bit of a beginner at Excel and have an annoyong problem that is
driving me mad! I have long lists of references with values in adjacent
cells. How do I total up the values and produce a list of non repeated
references. Better explained like this:

Here is my origional list:

REF Value
7 2.096
7 2.351
7 1.741
19 1.645
7 11.843
7 4.227
4 3.266
11 3.376
4 1.972
11 1.729

I need to quickly sort the references into totals, this table would
look like this:

REF Value
4 5.23
7 22.25
11 5.1
19 1.64

I can easily mannually do it by sorting A-Z then summing the values for
each reference. But with 1000's of refs it takes too long.

I would greatly appreciate any help with this simple yet very annoying
problem!

Thanks in advance,

Matt
TrafficBroker


--
trafficbroker
------------------------------------------------------------------------
trafficbroker's Profile: http://www.excelforum.com/member.php...o&userid=28710
View this thread: http://www.excelforum.com/showthread...hreadid=483964