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

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.

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

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,RO W(Sheet1!$A$1:$A$75)),ROWS($1:1)))," ")

HTH

"John B" wrote:

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.

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

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

"Toppers" wrote:

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,RO W(Sheet1!$A$1:$A$75)),ROWS($1:1)))," ")

HTH

"John B" wrote:

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.