Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003
It sounds like you could:
Select the range Data|Filter|autofilter And use the dropdown in each field to show the rows you want. And to see everything again: data|filter|show all phyllis_yeo wrote: Dear Excel Expertises, I have an Excel spreadsheet of with features and models. It looks like this in excel. The first column contains all the features and the first row contains all the models. Model_A Model_B Model_C Model_D Feature1 Y N Y Y Feature2 N N N Y Feature3 Y Y N N Feature4 Y Y Y N Feature5 N N Y Y Y means that the Model has the Features, while N means that the Model does not have the Features. What I want to do? a. I want to be able to select one or more features from a drop down menu with the whole list of Features (in first column). b. From the selection in (a), it will return me with all the models with "Y". E.g. If I select Feature3 and Feature4, it will return "Model_A" & "Model_B". E.g. If I select Feature4 only, it will return "Model_A", "Model_B" & "Model_C". Currently, I have a table of about 70 models and 50 features. How can I go about doing the above? Do I need to use Visual Basic? Thanks Experts!!! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible | Excel Worksheet Functions | |||
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Word 2003 Find/Change Automation from Excel 2003 crashes Excel 200 | Excel Programming | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |