Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default 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
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
How do I count the number of time 2 columns meet my criteria Mrswhit9 Excel Discussion (Misc queries) 2 November 22nd 09 10:19 PM
Sumproduct - meet multiple criteria from a list Tami Excel Worksheet Functions 6 August 29th 09 05:23 PM
How do I count the number of items that meet 2 criteria? 2seas Excel Worksheet Functions 5 March 15th 09 01:47 AM
Count the number of values in a list that meet certain criteria Fudgy Excel Worksheet Functions 1 May 5th 08 09:23 PM
How do I get the total number of items that meet 2 criteria in Exc Terri Excel Worksheet Functions 1 June 28th 06 10:48 PM


All times are GMT +1. The time now is 05:23 PM.

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

About Us

"It's about Microsoft Excel"