Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
get a list of sequence number that meet 3 criteria
How do you get a list of sequence numbers of 5 that meet 3 criteria? There are 1-59. I want to get a list of sequence numbers that consists of 5 number being called. Below are 3 criteria which consist of 24 to 28 group and each group has 1-3 numbers. Only one number is call from each group and no group will have two number call in the same sequence. There should be 5 number called. For example: 16 35 37 42 51
criteria 1 criteria 2 criteria 3 group 1 59 group 1 50 group 1 50 group 2 58 group 2 40 group 2 40 51 group 3 49 group 3 51 group 3 30 41 52 group 4 48 group 4 41 52 group 4 20 group 5 39 57 group 5 30 group 5 10 21 group 6 38 56 group 6 20 42 group 6 11 22 group 7 29 47 group 7 31 53 group 7 1 12 23 group 8 28 46 group 8 21 43 group 8 2 13 24 group 9 19 37 55 group 9 10 32 54 group 9 3 14 25 group 10 18 36 54 group 10 22 44 group 10 4 15 26 group 11 9 27 45 group 11 11 33 55 group 11 5 16 27 group 12 8 26 44 group 12 1 23 45 group 12 6 17 28 group 13 18 35 53 group 13 12 34 56 group 13 7 18 29 group 14 16 34 52 group 14 2 24 46 group 14 8 19 group 15 7 25 43 group 15 13 35 57 group 15 9 group 16 6 24 42 group 16 3 25 47 group 16 31 42 53 group 17 15 33 51 group 17 14 36 58 group 17 32 43 54 group 18 14 32 50 group 18 4 26 48 group 18 33 44 55 group 19 5 23 41 group 19 15 37 59 group 19 34 45 56 group 20 4 22 40 group 20 5 27 49 group 20 35 46 57 group 21 13 31 group 21 16 38 group 21 36 47 58 group 22 12 30 group 22 6 28 group 22 37 48 59 group 23 3 21 group 23 17 39 group 23 38 49 group 24 2 20 group 24 7 29 group 24 39 group 25 11 group 25 18 group 26 10 group 26 8 group 27 1 group 27 19 group 28 9 Submitted via EggHeadCafe - Software Developer Portal of Choice Coding Standards, Team Development, And You http://www.eggheadcafe.com/tutorials...s-team-de.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count the number of time 2 columns meet my criteria | Excel Discussion (Misc queries) | |||
Sumproduct - meet multiple criteria from a list | Excel Worksheet Functions | |||
How do I count the number of items that meet 2 criteria? | Excel Worksheet Functions | |||
Count the number of values in a list that meet certain criteria | Excel Worksheet Functions | |||
How do I get the total number of items that meet 2 criteria in Exc | Excel Worksheet Functions |