Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Brand selection from list
Hello All,
I have a list of 10 brands in columns A to J row 2 down for every row Each row represents one record(case). For each case i have to randoml select two brands for ratings, one in Column K and the second in colum L. For each case of the 10 brands, 6 to 7 brands are eligible fo selection and i have to pick two (one in column k and the other i column L. currently I can organize the data either as each column (A to J assigned to each of the 10 brands with a yes for all eligible brands i the corresponding row. I need a formula or a code that I can dynamically select the two brand of the eligible set of brands. Please help. Thanks, Zai Saki (means true friend:- -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make random selection from excel list? | Excel Discussion (Misc queries) | |||
Random Selection | New Users to Excel | |||
Random Selection | Excel Worksheet Functions | |||
How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |