1. D

    VBA code to highlight duplicates - all in the same colour across workbook

    Hi, I'm basically looking for a VBA that- - identifies duplicates across the whole workbook/multiple sheets - highlights duplicate cells to same random colour (preferably a light colour so text is still visible) - ignores blank cells Any ideas? Many thanks,
  2. A

    Duplicates Highlight with condition from second column

    Hello world, so I have the sheet as seen in the attachment (I have included a picture) I have 2 columns, A for machines, B for products. I want to highlight those products that are created from both machines , so something like if duplicate and column A in the range of the duplicates contains...
  3. B

    Highlight duplicates cells, but ignore cells with a ?

    I've basically got a column of names. I want to highlight duplicates. Conditional formatting works well, but but many cells in the column = "?" as a place holder. Obviously this will get flagged as a duplicate as well, but I want to take any cells that = "?" out of the running. So, basically...
  4. M

    Macro to help with a reporting feature!

    Hi all - I have been trying for a week now through chopping up bits of code to try perform a report function to help with some data analysis but it is hopeless and keeps failing. I have 3 sheets within my work book: Master Data Data Input Duplicates All three sheets contains the same headers...
  5. R

    google sheets: use numbered column to list duplicates in specific order

    Hello, I have a sheet of fictional data here: duplicates. Below is a screenshot for convenience. I'd like to list, in the duplicate column, duplicates of values in the id column, with one condition: that the corresponding row in the complete column must contain a 1, not a 0. Furthermore, I'd...
  6. B

    VBA - Identify / mark distinct values in a range without COUNTIF

    Please see below example table. Column A has random numbers between 1 to 100 Column B has the following formula copied down starting from B2: =IF(COUNTIF($A$2:A2,A2)=1,1,0) I would like to get value of 1 in column B if the row in column A is distinct, else 0. This works well only for small...

    Find Duplicates in Column A and

    Thank you in advance for any and all assistance. I'm trying to find all duplicate part# in column A and combine those part# count in column B into 1 part# in column C and the total count in column D
  8. E

    Highlight Duplicates Based on Adjacent Column

    Hi There! Hoping I can explain this well enough. In the attached sample file, I have product listed down column "C" to send to a store; then all of the stores listed "E:L". I want to have a macro in my personal book to read the active sheet and tell me by highlighting the cell red, if it's a...
  9. L

    Highlight 3 duplicates occurring within 3 days time

    I'm looking for a best way, most likely via Conditional Formatting, to highlight 3 reoccurring from B within 3 days time frame from A I've managed so far to get 3 reoccurring but for just 1 day So, all those 4 rows with PC should be highlighted, not just 3 of them Hope you can help
  10. U

    Duplicates based on the second attribute

    Hi, I have a data set with Unique Reference number repeating in a spread sheet. however, they have a second value based on which I would like to remove them from the spread sheet. as an example, Column A has the Unique Ref number for invoices with the corresponding issue dates in the Column...
  11. J

    Duplicates in RANK

    Hi there, So i have a bunch of stock price returns that i am ranking relative to one another. I am then trying to assign weights based on the highest 2 and lowest 2. These should sum to net 0. However, i occasionally have two stocks with 0% returns. This causes an issue whereby RANK obviously...
  12. H

    VBA to add alpha character to duplicate records

    Hello! I'm currently working on a spreadsheet where training is recorded. We're currently recording entries in two parts - First by training request, and then by courses scheduled. Each request is given a reference number, such as LT00001. Then each course is assigned an individual reference...
  13. T

    Highlight duplicates in 2 columns: Keep duplicates, delete rest

    Hi there, I am new to the forum since today because I am facing a problem highlighting duplicates in a large Excel file (at around 200.000 rows). Situation: Our suppliers sent a list with over 200000 rows in a file. I only need 1800 of them. I can identify the 1800 needed rows by the SKU...
  14. S

    Ranking Without Duplicates and NOT Skipping Ranks

    Hi there, Apologies if this is straight forward but I can't seem to arrive at a solution here. Trying to produce a rank for a column (column AA based on column Z in attached image) with unique ranks (no duplicates) and with no skipping rank numbers, currently using the below standard formula...
  15. A

    Xlookup With Duplicates in Return Array

    I’m tracking athletes top run times. Need to get top 3 times (including duplicates) and the associated dates. Dates are in row 1. Times start in row 2. I use SMALL to get best times. When using XLOOKUP to return the date, if a time is duplicated the formula pulls the date associated with the...
  16. Preccor

    Find duplicate values across multiple columns and multiple rows

    Hello, Is there a formula to find duplicate values across multiple columns and multiple rows? The file contains 9 columns and 5600 rows. The columns consist of phone numbers. The rows are the contact names labeled as "ID". I would like to find all duplicates so that I can clean up a database...
  17. Rita F

    Find , mark and filter duplicates at ListObject (column of Dynamic Table) VBA

    Hi I am trying to find, mark and filter duplicates at ListObject (column of Dynamic Table) VBA without success. The Following script works great for the regular range, I made some changes and need it for the list object. I will very much appreciate your assistance Sub Duplicates()...
  18. B

    =unique formula giving duplicates

    Hey all!! I have a unique problem... pardon the pun haha. I have a really simple equation =IFERROR(UNIQUE('Lims Report'!D7:D5000,FALSE,FALSE),"") This formula has always worked for a simple list with no duplicates, and now I have a list using this formula that has given me a duplicate :( Has...
  19. A

    Need to compare two columns and fetch the matching values in a new column

    Kindly check the attached and advise how can this be achieved. Thank you in advance. ABCDEFGHIJ1Value1Value2InvPriceValue1Value2InvPrice2ABCGHI527.94ABCABC527.943GHINone455.94GHIGHI455.944DMOPPM455.94PQSPQS284.945PQSAGI284.94AGIAGI584.946TTPDGS184.947AGIPQS584.948TOFABC684.9491011ORIGINAL...
  20. Sufiyan97

    Lookup Duplicate Values

    Hello all, I am using below formula to lookup duplicate values but not getting the result need help in this EFGHI1A1 AmountA1 DateB1 AmountDate2-5448.2207/16/2018-5,448.2205/29/2018Not Getting This I need Both this and next...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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