duplicate cells

Hi, I'm new to this forum so hope this hasn't been asked before. I have a large data set where I have rows that contain the same data on 2 columns. Let's call them ID number and Car Model. I only want to combine the rows IF ID + Car Make = ID + Car Make of another row (e.g. duplicate) AND the...

Hello, I'm looking for a count formula that counts the total number of sheets per person excluding duplicates. For example, below Nate has FTM01 and SM02 sheets assigned to him. His name is shown as 3 times in the table but the sheet names are the same for two of the items below. The answer...

Hello, Here is an example data table that would resemble mine. The columns with bold red text are the columns I need to develop a formula for: <tbody> A B C D E F G H I Task1 Task2 Task3 Task4 Task5 Row 1 1 1 1 2 2 3 4 4 1 2 3 4 Row 2 3 2 5 6 6 8 3 2 5 6 8 Row 3 2 2 2 1 1 5 8 2...

Hi all, I am trying to build a formula looking up text values and then sort them by Month and category <tbody> Date Category Color Result Jan Feb Mar 1/1/2016 A Red A Red, Grey Blue, Brown 5/2/2016 A Blue B Yellow 1/1/2016 B Yellow C...

Hello, I am trying to figure out a way to have a test column that can flag (i.e. YES or No) if a row has duplicate value across two or more columns like the following: <tbody> A B C D E Date 1 Date 2 Date 4 Date 5 Duplicate Dates? 12/23/2015 10:24 12/24/2015 20:22 12/29/2015 10:16...

Hi again, Thank you to those heroes that helped me with my question earlier today, but I've got another one. I'm trying to get this macro to highlight ONLY the 2nd, 3rd, 4th etc instance of a duplicate. I've since reverted to the original formula, but adding in a For...Each counter didn't...

Hi, I am trying to write a macro which highlights the second, and all following duplicates, in a table using ListObjects Unfortunately, it keeps returning an 'Object Required' error when arriving at the "countif" function. In the debug mode, the variable "Dupl_Cell" has a value when I hover...

I have a worksheet (about 75x2770) each 'data-object' or row has a unique excel id. There are duplicates from how the data was loaded into excel - the excel ID allows me to easily find the duplicates. I would like to keep a row based on the contents of 2 independent cells (in the same row)...

Hi, I've hit a wall! I am looking a solution to the below image. As you can see, Coloumn A has Order Number, B has weight and C has total weight. In C, is it possible to have a formula that will calculate the total weight of rows 5 & 6 as this is the same order.

i AM A high school student. In this excel document there is list of 100000 doctors. With their unique registeration number in a cell. Like this <tbody> Doc1 1234 adhh rnier Doc2 5678 dscu dcwofn Doc3 9012 ijwo dnw Doc1 1234 fne oeirfj </tbody> Here entire row is not duplicate But the...

Hi, I'm a little stuck!! I would like to delete rows based on duplicated text values (names) in column B. The end result would show all individual rows in the spreadsheet with no duplications in column B.

I am aiming to select a column and highlight any duplicate values as green. I would then like to instruct Excel to do 1 of 2 things in an If Then structure for the given range: 1) filter for any potential green cells and then end sub with "Complete" msgbox OR 2) if no cells were highlighted...

Hi. I am new to posting so hopefully I do this right. I can't figure out how to attach my file so I pasted part of it below the code. :rolleyes: I changed the actual text (I'm not working on animals) :laugh: Background: I have a template my team uses but the conditional formatting does not...

Hello, I'm somewhat new to forums so please bare with me. I tried finding a thread with a similar issue, but I don't know enough about macros to tailor someone else's solution to my own. For the life of me, I can't seem to find where to upload a sample workbook so I've attached a couple images...

<tbody> A B C D E F DESCRIPTION STOCK# PO REORDER# QTY SOLD TY QTY SOLD LY QTY SOLD TO DATE AA 1 FC1 6 3 18 AA 1 FC1 5 2 25 AA 1 FC1 1 5 63 BB 2 33 10 2 33 BB 2 33 5 5 18 BB 2 33 3 3 21 CC 3 15 6 9 19...

Hi Team, I'm in need of an excel formula or VBA Code that can assist me reference column of unique values (Column A) and have each of them duplicated in 11 rows of another column (Column B). For example: <TBODY> Column A Column B Apple Apple Orange Apple Mango Apple Apple Apple...

Hi, I have a large amount of data that contains a lot of duplicate records. The records can have different states but I just want to count the number of times a specific cell appears in the list of data, without removing duplicates. <TBODY> Tag?</SPAN> Insp. Date</SPAN> Insp. Time</SPAN>...

Hi, I have been trying unsuccessfully to create two macros in one dynamic worksheet (it changes all the time) using VBA. Ideally, macro 1 would highlight each row that has a match across columns A:D, and then macro 2 would then delete all matching rows. So, the worksheet is entitled "Template"...

Hey all, I have about 400 rows of data in Column A in a spreadsheet, and I need to take each individual row (in A) and copy/duplicate it twice, directly below the originals. For instance: OLD COLUMN A 1 2 3 ... NEW COLUMN A 1 1 1 2 2 2 3 3 3 ... ... ... Additionally, in Column B I have...

I got more than 1000 columns. Hence, removing duplicates in each column is time consuming. Could anyone suggests a VBA code that can solve this problem? Thanks in advance. Raw Data <tbody> Header1 Header2 Header3 Header4 48251 41253 474565 456 48251 2178965 474565 45612 48251 1235 45...