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!
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!
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks