| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create formula to choose price based on previous choice. | Excel Worksheet Functions | |||
| I am trying to create a form in Excel. In my form I want to be abl | Excel Discussion (Misc queries) | |||
| help - create a multiple choice test | Excel Discussion (Misc queries) | |||
| How do i create a multiple choice drop down list | Charts and Charting in Excel | |||
| Hiding rows based on choice in a listbox | Excel Discussion (Misc queries) | |||
![John B[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
