|
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
|
Print Thread
camieabz