Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
allocating numbers to cells
The numbers represent rounds.
So a name will go with a round (number) but some names know more than one round. Name a 1 name b 2 name c 3 name d knows round 1 and 2 name e knows round 2 and 3 Is there an automatic function that would allocate "name d" or "name e" to a round if "name a, b or c" were not available for that day? The table would look like this Name a 1 name b 2 name c 3 name d name e Say for example "name a" was not available how would "name d" get allocated to round 1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allocating percentages | Excel Discussion (Misc queries) | |||
Allocating remainders | Excel Worksheet Functions | |||
Allocating the numbers from the total | Excel Worksheet Functions | |||
Allocating a value from a cell | Excel Worksheet Functions | |||
Allocating a Value | Excel Worksheet Functions |