3 Column QUestion...need 3rd column that reads 1st, multiples by 2nd, and lists in 3rd column

[chiguy41]

i need a formula that reads a SKU number in column 1, reads column 2 to see how many times it will be listed in 3rd column. As you can see below, SKU A appears in Column 1 and the quantity in Column 2 is 1, so it only listed in the 3rd column (print) 1 time. But SKU B has 2 quantity so it is listed in Column 3 twice, SKU D is quantity 3 and listed 3 times in the 3rd column.

Any suggestions?

SKU	QTY	Print
A	1	A
B	2	B
C	1	B
D	3	C
E	2	D
F	1	D
G	2	D
H	2	E
I	1	E
		F
		G
		G
		H
		H
		I

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[azumi]

Deleted post<sumif($a$2:$a$10,$a$2:$a$10,$b$2:$b$10))),0)),"")< html=""></sumif($a$2:$a$10,$a$2:$a$10,$b$2:$b$10))),0)),"")<>

 

[azumi]

Sorry the formula not typed correctly

 

[azumi]

Trouble show formula correctly

Put this on C2

=IFERROR(INDEX($A$2:$A$10,MATCH(1,SIGN((COUNTIF($C$1:$C1,$A$2:$A$10)
SUMIF($A$2:$A$10,$A$2:$A$10,$B$2:$B$10))),0)),"")

array ENTERED and copied down

 

[azumi]

You need to add <, between First line formula and the second, sorry still troube

 

[chiguy41]

I put the formula in my excel sheet. The result was that i had Column C with empty cells, all of the cells were empty. did you receive a different result?

 

[azumi]

My bad, as your table Im assumed placed on A1:B10 (with headers), put this on C2 and copied down :

=LOOKUP(ROW(A1),SUMIF(OFFSET(B$1,,,ROW($1:$99),),"<>")+1,A$2:A$99)&""
this regular formula

or array formula

=IFERROR(INDEX($A$2:$A$10,MATCH(1,SIGN((COUNTIF($C$1:$C1,$A$2:$A$10)<SUMIF($A$2:$A$10,$A$2:$A$10,$B$2:$B$10))),0)),"")

this need press CTRL+SHIFT+ENTER button all together and then copied down

or see this
https://simpan.ugm.ac.id/public.php?service=files&t=13610b4344ac294ca9fcbdcbc8924158

 

[chiguy41]

Thank you so much. I tried both and they both work great. This is awesome. I understand the 1st formula more than the 2nd formula. I have lots of reading to do on IFERROR, INDEX AND SIGN. Again, thank you.