| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Long list into Table to contain only ten
Hey,
Im sure there is an easy answer to this but i cant come up with it. I have a long list of possible criteria's i want the user to pick ten out of the list by selecting yes from a drop down list next to the criteria. Once they have ticked yes i want it to appear in a second sheet with a table. When i have tried i am unable to do it without getting false or blank cells where the criteria hasnt been ticked Can anyone help with this? i need a formula that will aviod these false returns and just finds the next citeria that has been ticked yes. Thanks Chris EggHeadCafe - Software Developer Portal of Choice Run an ASP Page with parameters from SQL Server http://www.eggheadcafe.com/tutorials...with-para.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort a Table into one long list | Excel Discussion (Misc queries) | |||
| Summarised list from long list | Excel Discussion (Misc queries) | |||
| working with a long list | Excel Discussion (Misc queries) | |||
| names in a long list | Excel Worksheet Functions | |||
| Setting up a random list from long list of names ? | Excel Discussion (Misc queries) | |||
Threaded Mode
