+ Reply to Thread
Results 1 to 4 of 4

Issues with Randomizer

  1. #1
    Registered User
    Join Date
    10-22-2019
    Location
    California, US
    MS-Off Ver
    2016 (64-bit)
    Posts
    70

    Issues with Randomizer

    Found a small problem with the randomizer. I've attached a sample with the issue highlighted in red. The green area is what I desire. Don't recalculate again, or else it will change the highlighted issue.

    Appreciate the help in advance!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Referencing cells in a separate worksheet...

    Hi -

    Technically, since this is a new question, you're supposed to close this thread and open a new one with your new question. That way, if someone has your same problem, they can find the answer by searching thread titles. Please do that for future reference.

    As to your question, I think if you simply replace your duplicates formula with the following it will add a condition to your OR statement looking for opposites:

    =IF(OR(B3=C3,COUNTIFS(B:B,B3,C:C,C3)>1,COUNTIFS(C:C,B3,B:B,C3)>=1),"Duplicate","Good")

    Paste into D3 and copy down.

    Hope this helps.
    ____________________________________________
    If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

    If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2509 (Windows 11 Home 24H2 64-bit)
    Posts
    92,405

    Re: Issues with Randomizer

    Posts moved to a new thread.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  4. #4
    Registered User
    Join Date
    10-22-2019
    Location
    California, US
    MS-Off Ver
    2016 (64-bit)
    Posts
    70

    Re: Referencing cells in a separate worksheet...

    Quote Originally Posted by loginjmor View Post
    Hi -

    I think if you simply replace your duplicates formula with the following it will add a condition to your OR statement looking for opposites:

    =IF(OR(B3=C3,COUNTIFS(B:B,B3,C:C,C3)>1,COUNTIFS(C:C,B3,B:B,C3)>=1),"Duplicate","Good")

    Paste into D3 and copy down.

    Hope this helps.
    Thank you for the help!

+ 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. Grouping names randomizer
    By rps03 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2015, 11:40 AM
  2. vba: Team Randomizer
    By saikong051 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-11-2014, 11:23 AM
  3. [SOLVED] VBA: Team Randomizer or Generator
    By saikong051 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-17-2014, 09:35 AM
  4. List Randomizer
    By j_christley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-14-2013, 06:28 PM
  5. Creating a randomizer that counts down
    By dougiejdm in forum Excel General
    Replies: 1
    Last Post: 09-08-2010, 07:41 PM
  6. Randomizer with out duplicates
    By Treblig in forum Excel General
    Replies: 3
    Last Post: 07-15-2009, 02:58 PM
  7. Randomizer Help
    By MGMRAM in forum Excel General
    Replies: 6
    Last Post: 10-16-2006, 10:42 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