[Solved] How to divide amount automatically to complete the given target; if someone is on the leave

by 


cell A1 = **cris**
cell B1 = **john**
cell C1 = **bob**
cell D1 = **stev**
cell E1 = **david**
cell F1 = **michie**
cell G1 = **toney**
cell H1 = **jack**
cell I1 = **sese**

and

cell J1 = **cris**
cell K1 = **john**
cell L1 = **bob**
cell M1 = **stev**
cell N1 = **david**
cell O1 = **michie**
cell p1 = **toney**
cell q1 = **jack**
cell r1 = **sese**

now A to I is your worker availability to allocate work. If anyone leave just leave it blank otherwise any characters / numerals

then add the below formula to the cell j2

=IF(A2<>"",1800/COUNTA($A$2:$I$2),"")

and select the cells J2 to R2 and press CTRL + R

Hope you looking for this?

9

solved How to divide amount automatically to complete the given target; if someone is on the leave