Technical Discussion
  >> Windows Issues

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

  Print Thread
(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.

Part___________QTY_____________New list
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