duplicate combinations

  1. C

    Row by row comparison between 2 sheets - conditional formatting (changes/duplicates)

    Hey all! I'm trying to create a formula that can be used with conditional formatting to highlight changes, or duplicates, between 2 sheets, or 2 workbooks if that works better, on a row-by-row basis, for a week-by-week sales audit that we generate. I've tinkered with a bunch I've found online...
  2. C

    Highlighting duplicates between 2 sheets that contain different orderings

    Hey all! Any help with this problem I'm bamboozling myself with would be hugely appreciated! So I have two different sheets I'm looking to compare and highlight duplicates of: Sheet 1 - Contains all current employee names in a "firstname*space*surname" format. It also contains a " [C]" to...
  3. D

    Copy / Move Duplicate Entry

    I am kind of just brainstorming here. I have a massive list of contacts that I am try to clean to the best of my ability before handling an import. I have Account Numbers in column A and First / Last in B & C, column D are phone numbers & column E are extensions, and finally column F is the...
  4. J

    Duplicates values when using the "&" to join results

    Hello Guys, here is the situation: I created a formula to extract the date on a string of text from any position, and I used the IF function to show the same value is the Date is not in the text. Here is the example: FORMULA...
  5. szita2000

    How to find duplicates within 5 days of each other in data set

    <tbody>#DAE7F5[/URL] "] A B C D E 1 Date Name Product Concan Count 2 01/01/2018 Daffy Duck Apple Daffy DuckApple 0 3 03/01/2018 Bugs Bunny Pear 4 03/01/2018 Bugs Bunny Orange 5 07/01/2018 Bugs Bunny Orange 6 12/01/2018 Pepe Le Pew Kiwi 7 05/01/2018 Daffy Duck Apple...
  6. J

    Remove Duplicate Combinations

    Hi All, I am trying to compile a list of optimal fantasy football lineups, but I am running into a duplicate issue. I am able to have 3 wide-receivers playing in my lineup. I identified what I think are the top 75 wide receivers and plugged them in to Access to find all 405,150 possible...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top