Technical Discussion
  >> Windows Issues


Register (or login) on our website and you will not see this ad.


  Print Thread
Anonymous
(Unregistered)Tue 15-Feb-11 13:52:16
Print Post

Excel help please


[link to this post]
 
Hi - I could do with some quick help please.

If i have column A populated with a list of numbers ot text and in column B i have a qty for each of the entrys in to column A and say in column C i want a new list created from the list in column A and B that shows how times a certain string of text was repeated in column A and the total qty from column B for that string of text. Is there a formula i can use for this or would i have to use a pivot table.

A_____________B__________________C
Part___________QTY_____________New list
000000_________10
000011__________5
000000_________7
Standard User camieabz
(legend) Tue 15-Feb-11 13:54:21
Print Post

Re: Excel help please


[re: Anonymous] [link to this post]
 
See SUMIF and COUNTIF and perhaps INDEX.

~~~~~~~~~~



© Camieabz 2002-2011 - All rights and lefts reserved.

report this link
  Print Thread

Jump to