duplicates

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...

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: Master Data Data Input Duplicates All three sheets contains the same headers...

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...

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...

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

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...

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

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...

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...

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...

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...

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...

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...

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...

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()...

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...

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...

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...

Hi Friends, I been trying from few hours to clean and convert data into columns using excel formula. But its taking much to process huge data. I want take into different columns Like ColumnA ColumnB ColumnC ColumnD First Name Last Name Job title Company name Sample data sheet attached...