Removing duplicate numbers

[dp_fulcher]

Hi there,

I was wondering if anybody could offer me advice on removing duplicat
numbers in a workbook.

For example, column A has 5 rows of item "D111", with column
containing 5 rows of the same cost "$5".

What I would like to do is for each item (such as "D111") with a coun
greater than 1 return only one row of the cost (such as "$5" in th
example above), instead of 5 rows of the cost.

Otherwise, using the example above, when I go to sum the cost for ite
"D111", it would result in "$25", rather than "$5".

Any suggestions

 

[JulieD]

you might like to check out chip pearson's website he's got lots of info on
duplicates

http://www.cpearson.com/excel/duplicat.htm

Cheers

julieD

 

[Biff]

Also see one possible solution in .misc

Biff

-----Original Message-----
you might like to check out chip pearson's website he's got lots of info on
duplicates

http://www.cpearson.com/excel/duplicat.htm

Cheers

julieD






.