• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Workload change every 3 month base on number of recruit

Hi,

I want to designed workload for my staff. That workload will be change every 3 month starting from recruit date.
We just put number of recruitment in any month and workload will automatically calculate and change every 3 month.
Please refer to attached file for more detail.

Thanks,
 

Attachments

bosco_yip

Excel Ninja
Try,

In B5, array (CSE) formula copied across right :

=SUM(IFERROR(LOOKUP(COUNT($B2:B2)-AGGREGATE(15,6,COLUMN($A1:$L1)/($B3:B3<>""),COLUMN(INDIRECT("C1:C"&COUNT($B3:$M3),)))+1,IFERROR(LEFT($B8:$B11)+1,0),$C9:$C12)*INDEX($B3:$M3,N(IF(1,AGGREGATE(15,6,COLUMN($A1:$L1)/($B3:$M3<>""),COLUMN(INDIRECT("C1:C"&COUNT($B3:$M3),)))))),0))

71012
 

Attachments

Try,

In B5, array (CSE) formula copied across right :

=SUM(IFERROR(LOOKUP(COUNT($B2:B2)-AGGREGATE(15,6,COLUMN($A1:$L1)/($B3:B3<>""),COLUMN(INDIRECT("C1:C"&COUNT($B3:$M3),)))+1,IFERROR(LEFT($B8:$B11)+1,0),$C9:$C12)*INDEX($B3:$M3,N(IF(1,AGGREGATE(15,6,COLUMN($A1:$L1)/($B3:$M3<>""),COLUMN(INDIRECT("C1:C"&COUNT($B3:$M3),)))))),0))

View attachment 71012
It works magically as expected. Thanks
 
Top