• 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.

Divide rows evenly among employees

Z

zohaib

Member
Hello,

I have attached an example sheet. What I am trying to do is fill column A with employee names evenly. Currently, there are 5 ppl I would like to divide this data between.

Thanks,
Zohaib
 

Attachments

  • Book2.xlsx
    9.5 KB · Views: 11
If you had a list of employees starting in M1:M5, then you could put this formula in A2, copy down.
=INDEX(M:M,MOD(INT((ROW(A1)-1)/INT((COUNTA(B:B)-1)/COUNTA(M:M))),COUNTA(B:B)-1)+1)
 
You must log in or register to reply here.
Back
Top