+ Reply to Thread
Results 1 to 12 of 12

Need to divide list

  1. #1
    Registered User
    Join Date
    06-20-2022
    Location
    Doha,Qatar
    MS-Off Ver
    2019
    Posts
    6

    Need to divide list

    Number of staff working changes everytime with new file.
    Number of booking code changes everytime with new file.
    List must be divided evenly as much as possible without deleting duplicate booking code.
    The duplicate booking code should be counted as 1 while allocating the satff
    Attached Files Attached Files
    Last edited by KrishnaR; 06-25-2022 at 10:12 AM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,058

    Re: Need to divide list

    With a pivot table.

    See the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    06-20-2022
    Location
    Doha,Qatar
    MS-Off Ver
    2019
    Posts
    6

    Re: Need to divide list

    Thank you for your promt response but it quite did not help me.
    For eg, I need to divide this list among 4 staff. How do i do it?

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,058

    Re: Need to divide list

    You did not manualy adde the expected result, so members guesses what should be done.

  5. #5
    Registered User
    Join Date
    06-20-2022
    Location
    Doha,Qatar
    MS-Off Ver
    2019
    Posts
    6
    Kindly check if you can see my desired result
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,058

    Re: Need to divide list

    "Kindly check if you can see my desired result"

    You posted the same file as in #1

  7. #7
    Registered User
    Join Date
    06-20-2022
    Location
    Doha,Qatar
    MS-Off Ver
    2019
    Posts
    6

    wrong file

    Here it is. Sorry about that.
    Attached Files Attached Files
    Last edited by KrishnaR; 06-20-2022 at 10:59 AM. Reason: wrong file

  8. #8
    Registered User
    Join Date
    06-20-2022
    Location
    Doha,Qatar
    MS-Off Ver
    2019
    Posts
    6
    Here it is. Sorry about that.[/QUOTE]
    Attached Files Attached Files

  9. #9
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,058

    Re: Need to divide list

    C2="staf"&INT((ROW()-1)/MROUND(COUNTA($A$2:$A$20)/3,0.5))+1

    See the attached file.
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    06-20-2022
    Location
    Doha,Qatar
    MS-Off Ver
    2019
    Posts
    6

    Re: Need to divide list

    same booking code is getting allocated for staff1 and staff 2.


    for eg .

    GSJSJ5 staff 1 staf1
    GSJSJ5 staff 1 staf2

    duplicate codes should be allocated to same staff.

    This is the last problem.
    thank you.

  11. #11
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,058

    Re: Need to divide list

    My second solutions are equal to your manual inputted data.

    Since you don't show the expected results.

    The answer is:
    staff 1=7
    staff 2=5
    staff 3=7

    Try this one.

    See the attached file.
    Attached Files Attached Files

  12. #12
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,058

    Re: Need to divide list

    Thanks for the rep.

    Glad I could help.

    If you are satisfied with the solution, please mark the question solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Divide each column value by list of other values.
    By WolfX2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-18-2018, 06:15 AM
  2. Using a function to take a list and divide it into two columns
    By fjyoder in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-27-2015, 04:33 PM
  3. Divide a list
    By arpanjain01 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-12-2012, 10:10 PM
  4. divide value and copy at the end of the list
    By fabdav in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2011, 10:12 AM
  5. Automatically divide list into even segments
    By ffmariners in forum Excel General
    Replies: 5
    Last Post: 01-29-2010, 12:23 AM
  6. divide list into equal parts
    By robotlust in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2008, 11:28 PM
  7. Replies: 2
    Last Post: 03-14-2007, 01:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1