Delete duplicates: Sum Values & Consolidate Data

[evoxfan]

I have three columns with a cost code, description, and amount such as listed
below.

071.300 Waterproofing Systems $1,000
071.300 Waterproofing Systems $1,000
071.420 Hot Fluid-Applied Water $1,000
074.110 Metal Roof Panels $1,000
074.110 Metal Roof Panels $1,000

I would like to sum and consolidate the amounts for each cost code so that I
do not have duplicates.

Such as with the above list I would like it to show:
071.300 Waterproofing Systems $2,000
071.420 Hot Fluid-Applied Water $1,000
074.110 Metal Roof Panels $2,000

What is the best way to accomplish this?

 

[Tom [Pepper] Willett]

This is a FrontPage newsgroup, try an Excel group.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage
---------------------------
:I have three columns with a cost code, description, and amount such as
listed
: below.
:
: 071.300 Waterproofing Systems $1,000
: 071.300 Waterproofing Systems $1,000
: 071.420 Hot Fluid-Applied Water $1,000
: 074.110 Metal Roof Panels $1,000
: 074.110 Metal Roof Panels $1,000
:
: I would like to sum and consolidate the amounts for each cost code so that
I
: do not have duplicates.
:
: Such as with the above list I would like it to show:
: 071.300 Waterproofing Systems $2,000
: 071.420 Hot Fluid-Applied Water $1,000
: 074.110 Metal Roof Panels $2,000
:
: What is the best way to accomplish this?

 

[Murray]

Too bad that "E" and "F" are so close in the alphabet, no?

 

[Tom [Pepper] Willett]

Too bad they can't read ;-)

: Too bad that "E" and "F" are so close in the alphabet, no?
:
: --
: Murray
: MVP Expression Web
:
:
: : > This is a FrontPage newsgroup, try an Excel group.
: > --
: > Tom [Pepper] Willett
: > Microsoft MVP - FrontPage
: > ---------------------------
: > : > :I have three columns with a cost code, description, and amount such as
: > listed
: > : below.
: > :
: > : 071.300 Waterproofing Systems $1,000
: > : 071.300 Waterproofing Systems $1,000
: > : 071.420 Hot Fluid-Applied Water $1,000
: > : 074.110 Metal Roof Panels $1,000
: > : 074.110 Metal Roof Panels $1,000
: > :
: > : I would like to sum and consolidate the amounts for each cost code so
: > that
: > I
: > : do not have duplicates.
: > :
: > : Such as with the above list I would like it to show:
: > : 071.300 Waterproofing Systems $2,000
: > : 071.420 Hot Fluid-Applied Water $1,000
: > : 074.110 Metal Roof Panels $2,000
: > :
: > : What is the best way to accomplish this?
: >
: >
:

 

[Rob Giordano [MS MVP]]

In an accounting system
In an estimating system

Definitely not in MS FrontPage!