Not even sure this is possible.

F

Fraser B

ok, what i am trying to do is to search a list of product codes looking for
duplicate codes. where a duplicate code is found i would like it to add the
product quantity together.

if there is four duplicate codes in the list to add all four together, then
to put the code and the total product quantity into a new cell.

it is important that i would like this to be automated and that i will not
know what im searching for. i.e. if the list contains a1, a2, a3, a4, a3,
a5, a1, a5

then i would like it to automatically produce a list of the total sums of
all A1's A2's A3's A4's and A5's

i hope this makes sense.

like i said in the title im not sure if it is possible to do this without
having something you are actually seraching for.

well hope to hear back form anyone that might be able to help

many thanks in advance

fraser
 
P

Pecoflyer

Fraser said:
ok, what i am trying to do is to search a list of product codes looking
for
duplicate codes. where a duplicate code is found i would like it to
add the
product quantity together.

if there is four duplicate codes in the list to add all four together,
then
to put the code and the total product quantity into a new cell.

it is important that i would like this to be automated and that i will
not
know what im searching for. i.e. if the list contains a1, a2, a3, a4,
a3,
a5, a1, a5

then i would like it to automatically produce a list of the total sums
of
all A1's A2's A3's A4's and A5's

i hope this makes sense.

like i said in the title im not sure if it is possible to do this
without
having something you are actually seraching for.

well hope to hear back form anyone that might be able to help

many thanks in advance

fraser

One of the possibilities would be to use a Pivot Table. You'll find
info at 'this site' (http://peltiertech.com/Excel/Pivots/pivotstart.htm)

another one, after sorting your codes would be the SUBTOTAL function


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faster
 
G

GoBow777

'Fraser B[_2_ said:
;796579']ok, what i am trying to do is to search a list of product codes
looking for
duplicate codes. where a duplicate code is found i would like it to
add the
product quantity together.

if there is four duplicate codes in the list to add all four together,
then
to put the code and the total product quantity into a new cell.

it is important that i would like this to be automated and that i will
not
know what im searching for. i.e. if the list contains a1, a2, a3, a4,
a3,
a5, a1, a5

then i would like it to automatically produce a list of the total sums
of
all A1's A2's A3's A4's and A5's

i hope this makes sense.

like i said in the title im not sure if it is possible to do this
without
having something you are actually seraching for.

well hope to hear back form anyone that might be able to help

many thanks in advance

fraser

I think this is what your asking for.


+-------------------------------------------------------------------+
|Filename: GoBow777.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=128|
+-------------------------------------------------------------------+
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top