Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Objective: create a program (with VBA) that allows me to exclude number
in a logical way. Details: I've got 100 sets of 7 numbers each. In this 100 sets ther are 30 sets that, if we exclude them (along with their numbers), we ge the next set. I've been thinking about this problem for a while and i know, almos for sure, that there is only one combination of these sets that mak this possible! As we add up more new sets, we take the oldest out. This results in dynamic "set of sets". And we get always different combinations of set to exclude. If this isn't clear enough but you think you have the solution,pleas post it and I will try to clear it out. Thank you very much for your attention Nun -- Message posted from http://www.ExcelForum.com |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I don't have a solution set, but I could set up somethinh if you set a reply
with a clearer explanation. Maybe you want to supply some example data :) Rob "PeaceMaker " wrote in message ... Objective: create a program (with VBA) that allows me to exclude numbers in a logical way. Details: I've got 100 sets of 7 numbers each. In this 100 sets there are 30 sets that, if we exclude them (along with their numbers), we get the next set. I've been thinking about this problem for a while and i know, almost for sure, that there is only one combination of these sets that make this possible! As we add up more new sets, we take the oldest out. This results in a dynamic "set of sets". And we get always different combinations of sets to exclude. If this isn't clear enough but you think you have the solution,please post it and I will try to clear it out. Thank you very much for your attention Nuno --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Random Numbers excluding Previous Numbers | Excel Worksheet Functions | |||
Excluding Negative Numbers | Excel Worksheet Functions | |||
Excluding Repeating Numbers Help!1 | Excel Worksheet Functions | |||
Excluding numbers in a total | Excel Discussion (Misc queries) | |||
Averaging excluding min and max numbers | Excel Worksheet Functions |