Forum Discussion
Solved
How to print rows based on its quantity in a different table?
Hello wonderful community, I have a table of Material List and its respective quantity. In a different output table, I want to be able to print the Material into rows depending on its number of q...
afzalbaharudin If you wish to go with excel formulas only then could try-
=UNIQUE(CHOOSE({1,2},D2:D13,COUNTIFS(D2:D13,D2:D13)))