Hello
I am a novice at using excel, although I am learning and am proud of what I have learned so far.
I am sure that others have asked the same question I am asking now, however I did not come across any solution that fits my needs.
I am aware that to some of you my question may seems silly and obvious, so I apologies in advance, but to me its like trying to find a needle in a haystack. so here goes nothing:
I have a problem with:" splitting a value into multiple equal (as much as possible) parts based on specific number.
example:
column A (Levels) Column B (number of employ) Column C (number of groups) level 3 35 3 groups level 4 8 1 groups level 5 22 2 groups level 6 10 6 groups level 7 1 1 groups level 8 0 0 groups
Note: in Column C
number of groups ( maximum number of groups possible at any given time is 8 groups)
so in new columns (F:M) I want to split (the total number of employ)based on (the number of groups) for each level and show that across different columns (F:M):
column E (LEVEL) column F (1 G) Column G (2 G) Column H (3 G) Column I (4 G) Column J (5 G) Column K (6 G) Column L (7 G) Column M (8 G) level 3,totola 35,split to 3 groups 12 12 11 0 0 0 0 0 level 4,totola 38,split to 1 groups 8 0 0 0 0 0 0 0 level 5,totola 22,split to 2 groups 11 11 0 0 0 0 0 0 level 6,totola 10,split to 6 groups 2 2 2 2 1 1 0 0 level 7,totola 1,split to 1 groups 1 0 0 0 0 0 0 0 level 8,totola 0,split to 0 groups 0 0 0 0 0 0 0 0
I am not sure what formula to use!! please help??
I am not sure if this is even feasible with the layout I am presenting, please advise!!
PS: I am using excel Microsoft 365
PPS: English is not my first language so please excuse any misspellings/phrases.
Thank you so so much in advance
Bookmarks