+ Reply to Thread
Results 1 to 3 of 3

Help comparing data and assigning random tasks w/out duplicates

  1. #1
    Registered User
    Join Date
    04-21-2020
    Location
    Georgia
    MS-Off Ver
    2008
    Posts
    2

    Help comparing data and assigning random tasks w/out duplicates

    I need to assign tasks to people that have not done the task in the last year. There are about 4,000 tasks, and seven people. I've been manually comparing who has performed these tasks but am hoping that there is a way for Excel or the Google Sheet to look at the task and assign it to someone that has not performed it. The tasks will accumulate quarterly, so next quarter there will be a few hundred added. Any ideas?

    Example: Task #1 has been completed by Joe, Sally, and Sarah. It can be assigned to Mary, Jane, Sue, or Tom.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,620

    Re: Help comparing data and assigning random tasks w/out duplicates

    Please read the yellow banner at the top of the page. Or skip to extended version of it below:

    Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If there are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, empty cells between data, mixed text/numbers, etc. - please show them all, or at least indicate in text). The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

    3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

    To attach an Excel file you have to do the following (paperclip icon does not work!): Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    04-21-2020
    Location
    Georgia
    MS-Off Ver
    2008
    Posts
    2

    Re: Help comparing data and assigning random tasks w/out duplicates

    Thank you, yes I will attach a sample. It will take a little while to be able to create the example without identifying info but I will post it as soon as I'm able to.

+ 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. Need VBA or Formula for assigning tasks
    By JVCXQC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2020, 07:53 AM
  2. Assigning tasks to team with each task having specific weights
    By chrysocollamalachite in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2019, 05:47 AM
  3. Assigning tasks to team members based on a few criteria
    By enguehard in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-03-2018, 09:08 AM
  4. Replies: 4
    Last Post: 02-05-2016, 03:20 PM
  5. Comparing Data and Duplicates
    By sweedey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2014, 04:59 PM
  6. Comparing data with duplicates
    By Zapster310 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2013, 03:50 PM
  7. Random names to random tasks
    By aquinlan in forum Excel General
    Replies: 8
    Last Post: 06-18-2010, 05:57 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