duplicates cells

  1. J

    Highlighting duplicates of combined cells

    Hello, I am trying to highlight all duplicated combination of 2 cells. Both cells are always numbers and I would like to see if there is already the same combination without adding a new column. An example is: 20 50 20 30 20 50 15 4 I would therefore need Excel to highlight 1st...
    • JanaD
    • Thread
    • conditional formatting duplicates cells excel
    • Replies: 3
    • Forum: Excel Questions
  2. X

    Drop Down with no duplicates in the cells

    I'm creating a work schedule and currently the excel allows me to select from a drop down using data values. What I'm looking for is a way (formula) that recognizes a duplicate in the cells I have listed below. Yellow is Names drop down (don't care about duplicates there. White has drop down for...
  3. frank265

    Help to find the right duplicates?

    Hi, I was hoping someone smarter than me might be able to help me with this excel conundrum... I have some software which can look for duplicate images on a hard drive and then export the results into a csv file. As you will see from the spreadsheet below it pairs the duplicates into what it...
  4. W

    VBA code remove duplicates from a filter

    Can someone help me with VBA code that does the following. I will explain what I have been doing manually in the sheet. will apply conditional formatting to highlight duplicates in column A. Will filter "yes" from column B and then will filter by color of red from A (highlighted ones from...
    • Wafee
    • Thread
    • conditioal formatting duplicates cells excel vba
    • Replies: 9
    • Forum: Excel Questions
  5. M

    Delete duplicates cells

    I have tried the below macro and it is working but when applying it on a larger range of data (specifically 17137 rows) a considerable amount of data are deleted not just the duplicates RemoveDupes add blank Sub RemoveDupes() Dim X As Long For X = 1 To Range("A" & Rows.Count).End(xlUp).Row...

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