LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Multiple Drop down lists and their combnation

I am trying to create multiple distribution lists in A1 to D1, all these
distribution lists have different text in them.
Now, my problem is that "Is there any way in excel using which I can get the
result of any combination in cell E1"......

For Example:
If I have 5 different items in each distribution list from A1-D1, it means
that I can have 5X5X5X5=625 possible outcomes. But I know that only certain
number of outcomes are useful for me...let's say... 50 among these all are
useful and I know what are their respective combintions in cell A1-D1.

So, my question is ""Is there any way using whch I can input details for all
these 50 useful outcomes and get their result in cell E1 with the help of my
selection in cell A1-D1""????
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multiple dependent drop down lists Mikej Excel Worksheet Functions 6 April 15th 10 02:11 PM
Drop down lists from multiple source lists RoofIL Excel Worksheet Functions 3 February 18th 10 09:44 PM
Multiple drop-down lists to get a value PCoyne Excel Discussion (Misc queries) 8 July 3rd 07 03:06 PM
Multiple lists with repeated values for dependet drop down lists mcmanusb Excel Worksheet Functions 1 September 29th 06 12:13 AM
multiple drop down lists jason n z Excel Discussion (Misc queries) 1 March 10th 05 01:24 AM


All times are GMT +1. The time now is 10:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"