+ Reply to Thread
Results 1 to 4 of 4

How To Do No Duplicates - Almost There!

  1. #1
    Registered User
    Join Date
    01-28-2020
    Location
    Austin, Texas
    MS-Off Ver
    Office365
    Posts
    2

    Question How To Do No Duplicates - Almost There!

    I have three columns which I am running an equation on to generate a random selection. The first column (B3:B18) is the names of those requesting a class, the second (C3:C18) is a column with randomly generated numbers, and the third (D3:D18) ranks the requestors as either 0,1, or 2. The following formula will randomly select a name from the list.

    =IF(ISNUMBER(MATCH(Requesters!G3,GISTeam,0)),Requesters!G3,(IFERROR(INDEX(Class2,LARGE(IF(Requesters!I3:I18="0",ROW(G$3:G$18)-ROW(G$3)+1),INT(RAND()*COUNTIF(G$3:G$18,"0")+1))),(INDEX(Class2,LARGE(IF(Requesters!I3:I18="1",ROW(G$3:G$18)-ROW(G$3)+1),INT(RAND()*COUNTIF(G$3:G$18,"0")+1)))))))

    This formula is working as it should, but I have one problem. I don't want it to generate duplicate values. If I use this formula: =INDEX(Class1,RANK(Requesters!C3,Requesters!C$3:C$18)), I can get it to generate unique values, but I can't figure out how to combine the two together.

    Thank you for your help! I have attached the file.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,430

    Re: How To Do No Duplicates - Almost There!

    Try the following:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    01-28-2020
    Location
    Austin, Texas
    MS-Off Ver
    Office365
    Posts
    2

    Re: How To Do No Duplicates - Almost There!

    Thank you for your help! That seems to be working as we need! You are a lifesaver!

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,430

    Re: How To Do No Duplicates - Almost There!

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ 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. Replies: 6
    Last Post: 11-27-2018, 07:17 AM
  2. Replies: 5
    Last Post: 08-28-2018, 04:47 PM
  3. [SOLVED] Macro to find duplicates, concatenate cells, then delete old duplicates (2)
    By cny in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2016, 06:05 AM
  4. Replies: 2
    Last Post: 12-27-2013, 09:24 AM
  5. [SOLVED] Macro to find duplicates, concatenate Unique Values, then delete old duplicates
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2013, 04:32 PM
  6. Replies: 17
    Last Post: 07-05-2011, 05:37 PM
  7. Replies: 3
    Last Post: 03-09-2011, 07:00 PM

Tags for this Thread

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