excel how to take choice of 75 rows - create form of 10 selectons

J

John B

I have an excel worksheet with say 75 choices. Someone would typically
select say 8-10 of these choices with a quantity of 1. How do I take those
10 choices and automatically generate a form (report) that shows just those
selections chosen (ordered) in contigous rows.
 
T

Toppers

Assuming choices are in Column A and Quantity in Column B (value of 1) then
on Sheet1 then on Sheet2 , starting in A1 try:


=IF(ROWS($1:1)<=COUNTIF(Sheet1!$B$1:$B$75,1),INDEX(Sheet1!$A$1:$A$75,SMALL(IF(Sheet1!$B$1:$B$75=1,ROW(Sheet1!$A$1:$A$75)),ROWS($1:1)))," ")

HTH
 
T

Toppers

...... enter with Ctrl+Shift +Enter and copy down for 10 or more rows (for
maximum selection)
 
Top