Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help - how to move cells into an array using criteria
hi everyone - we need to assign students to testing groups which consist of
four people, but they cannot be from the same class, and their homeroom teachers cannot be their test proctors. so we have a long (1500 or so) list of ID numbers, in the next column their class #s, and in the next column their homeroom teacher. is there any way to automatically assign them to particular groups and times so that the two exclusionary criteria are met? thanks for the help, not sure if this is possible in excel but thought i'd give it a try bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding cells in an array with criteria | New Users to Excel | |||
Match criteria with an array of criteria | Excel Worksheet Functions | |||
If a criteria isn't met, move to the next line.... | Excel Discussion (Misc queries) | |||
Searching for a criteria in array of cells within an IF statement | Excel Worksheet Functions | |||
Cannot copy or move array entered formulas ... shared workbk | Excel Worksheet Functions |