Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am stuck
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am stuck
On Mar 4, 5:59*am, Ujpest wrote:
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 Not quite sure exactly what's intended here, but maybe this will help get started. I put the prescribed data in columns A1:B3 with the two extra names in A4:A5. Then I put this in B4: =IF(COUNTIF(B1:B3,1)=0,1,IF(COUNTIF(B1:B3,2)=0,2," ")) and this in B5: =IF(COUNTIF(B1:B4,2)=0,2,IF(COUNTIF(B1:B4,3)=0,3," ")) With this setup, I can delete any one number from B1:B3, or any two of them, and the extra names get allocated the unassigned rounds. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stuck! Please help | Excel Worksheet Functions | |||
Help, please, I'm stuck | Excel Discussion (Misc queries) | |||
HELP!! It's STuck | Excel Discussion (Misc queries) | |||
Stuck... | Excel Discussion (Misc queries) | |||
Please help, I'm stuck | Excel Discussion (Misc queries) |