Thanks for that, but havign just had a quick read i dont think that will help
either. Perhaps a more detailed example will give a clearer picture of what i
am trying to achieve:

I have two columns; NAME and PICK QUANTITY. When a worker finishes what they
are picking they enter there name in the "NAME" column and the total units
they have picked in the "PICK QUANTITY" column. Obviuosly throughout a day
this list would get quite long. In seperate columns i would have the picker
names and the cell adjacent would have a running total which updates the
addition of any new entries in the "pick quantity" column:

NAME PICK QUANTITY

Mr Smith 100 Mr
Smith 150
Mr Jones 20
Mr Jones 20
Mr Bloggs 46
Mr Bloggs 60
Mr Mooney 30 Mr
Mooney 30
Mr Smith 50
Mr Bloggs 14


I hope the example above makes it clearer!!!

Thanks

Andy Webb


"Niek Otten" wrote:

Read HELP for the DataSubtotal command

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"we88y" wrote in message
...
for example i have a column with names in and another column with numbers
in.
I want, in a seperate cell, to search the name column and if there are
duplicates of a name to add the numbers up in the corresponding cells. Is
this possible...HELP!"!