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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
...... enter with Ctrl+Shift +Enter and copy down for 10 or more rows (for
maximum selection)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Multiple sets of Option Buttons (Form Control) In Excell 2
how to delete an excel line based on a condition 2
Pivot tables - how do I change default from "count of" to "sum of" 2
Retrieve and group row data by multiple critieria 4
Conditional format row based on percentile 3
Macro for multiple rows 3
Summing weekly values to fall into correct month 2
How to add continuous 5 or 10 rows by giving number of rows to ad 3

Back
Top