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
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...
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...
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:
All three sheets contains the same headers...
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...
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:
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...
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...
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
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...
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...
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...
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).
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...
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...
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...
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...
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
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 :(
Kindly check the attached and advise how can this be achieved. Thank you in advance.
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...