Finding Duplicates In Two Seperate Columns

Sep 16, 2008

This should be an easy one, it has slipped my mind.

I have columns A and B, I want to find any names that appear in both column A and column B. I want them to show in a certain color.

View 11 Replies


Finding Duplicates In Different Columns

Aug 23, 2012

I'm trying to condense my email lists in order to stop people receiving the same email having signed up to several lists. How do I compare 5 different columns to find email addresses which appear in more than one...

View 1 Replies View Related

Text To Columns: Split Data In Seperate Seperate Coloumn

Jul 23, 2009

Attached file where i m not able to split data in seperate seperate coloumn

View 3 Replies View Related

Mark Duplicates That Are Identified In A Seperate Column

May 7, 2007

I am looking for a way to ease a 24,000 line duplicate list into showing just the files from a specific folder/subfolder and its dupes. I have marked the files that reside in that folder by adding a column and entering a "1" in it. What I am looking for is a way to add that "1" to the others of that unique numerical ID duplicates, so I can sort and trim the list to just those files. End result is to show files in one folder and the locations of duplicates of those files elsewhere for eventual cleanup.

Very loosely, if C2=C1 and B1=1, then make B2=1 (and so on)
(A is blank and only there in case a formula needs input there)


View 9 Replies View Related

Finding Intersection On Seperate Worksheet

Sep 10, 2006

I cannot figure the formula for finding an intersection of two points on a seperate worksheet. I have attached the workbook.

View 6 Replies View Related

Match 2 Columns To 2 Seperate Worksheet Columns

Sep 11, 2006

Now i have one excel sheet with two separet sheets in it ( Sheet 1 ) and ( Sheet 2 ) . I have in sheet 1 a column A with material codes and ColB is discreption and Col C IS Prices . But in Sheet 2 Col D is materila Code and Col I is a price .

the recordes in sheet 1 are around 11000 but in sheet 2 are around 2200 where the sheet 2 has a specific materials from sheet 1 .

Now i want to update the prices in sheet 2 from sheet 1 for each item after confirm that the materila code in sheet 2 equal in sheet 1 so copy the price from sheet 1 to sheet 2

Sheet 2 is old prices and sheet 1 has new prices so i need update the new prices in sheet 2

View 9 Replies View Related

Finding Max Value In Duplicates

Jul 22, 2009

I have data that has about 10 duplicate values (UTC Time) in one column and another column with number values (depth ft) that vary. I need to obtain the maximum (highest) value in the depth column and remove the other duplicates to filter out the low values. So for the data example below for UTC 15:56:28 I only want the 5.7 row, for 15:56:29 I want5.3 row and so on. I can attach the sheet. - this is a huuge dataset so manual filtering wont work. Data is from a sonar that gives 10 depth readings per second - I only need one depth tat is the highest value.


View 3 Replies View Related

Finding Duplicates ...

Oct 3, 2009

I have a workbook that I want to find if I have any duplicate numbers in a specific area.

The area of cells that I am checking is C3 through AO70

I am checking for numbers between 95 and 800. These are all ID# of individuals and not all the numbers between 95 and 800 are used. IE: 97 through 100 are not used ect.

I have already written a macro that does something else and I can use it to check each number as it comes up. However, once the number comes up I don't know how to use it to check the area.

If I can check all the area at one time to find duplicates it would be easier.

I do not know how to do either way but I can adapt my macro to whatever way is possible.

View 9 Replies View Related

Filtering Data In 2 Seperate Columns

Feb 25, 2007

I'm trying to put together a sheet to track football results. For simplicity sake, the sheet looks like this...

Home ; Away ; For ; Against ;
a ; b ; 2 ; 0
c ; d ; 1 ; 1
b ; c ; 1 ; 3
d ; a ; 2 ; 4
a ; c ; 1 ; 2

By using Autofilter on the home or away columns, i can obviously filter it in order that I can see all A's home results or all of A's away results, but by doing this you can't just filter the sheet in order to see the results of every game A plays in. I have a feeling that I need to do something with Advanced filter but have been playing around with this and not getting any joy. Can anyone advise on what I need to do?

Ultimately, my end goal would be to be able to create a drop down list where i would select the team from a list of all teams and this would automatically filter the sheet to their results only (and then I could use an autofilter to look at just homes or aways).

View 9 Replies View Related

Finding And Listing Duplicates

Feb 7, 2014

I have a workbook of appointments, I need a formula to list duplicate appointments and display them using 2 criteria (date and time).

See attached workbook : duplicate entries.xlsx‎

View 7 Replies View Related

Finding Duplicates Between 2 Rows ...

Jun 25, 2008

Just wondering if anyone has a macro, or formula that would allow me to find out (and possibly highlight), when any value in column A is equal to any value in column B. Im dealing with about 2000 rows so its almost impossible to complete manually.

Sorry the heading is supposed to read need help finding duplicates between 2 COLUMNS

View 14 Replies View Related

Finding Duplicates With Condition

Oct 10, 2008

way to wrap or format anything in this post. I dont think the text I put here is code, but I want to be sure, after receiving a moderators infraction for failing to properly wrap code in a previous post.


I have a wks in which the first column is a list account #'s and the folowing columns are specifics of transactions or interactions.

Lets say it is a movie rental customer list that lists each rental, and column "A" is the customer number, column "B" declares if it was returned late.

I need to compile a list of "all" rentals by customers who have "EVER" had a "late return" or a "YES" in column "B".

I need to find all account records/rows of accounts that at any time had a "YES" in column "B" even if the some or many of that customers rentals/entries have "NO" in column "B"

so say: ...

View 14 Replies View Related

Finding Duplicates Out Of Millions

Oct 22, 2009

I have to scrub files of 20,000 phones numbers against a file of several million phone numbers on the national do not call list.

On sheet one I have all 20,0000 phone number and then on sheet two in 5 columns I have roughly 2 million phone numbers. I need to know if any of the 20,000 phone numbers are in the 2 million on sheet two.

Right now I am simply using a vlookup formula but it is taking a very long time to update all of the fields.

View 9 Replies View Related

Finding Duplicates (sort Of)

Jan 28, 2010

I have a spreadsheet with 7000 lines exported from a database. I'm looking for lines that exist with an @@2 that don't have a corresponding @@1. Let me explain.


I want to keep the first two lines because there is an @@1 associated with an @@2. I'm looking to single out and delete lines that have @@2 that don't have a corresponding @@1 associated with it.

View 9 Replies View Related

Parse Data In Column A To Seperate Columns

Nov 30, 2008

See attached spreadsheet. I need to have all the data which is held in 1 row in column A seperated into its own column automatically. The order i need the data to be in is as follows

Date(pink), Time(red), Racecourse(green), Race Type(black), Class Of Race(purple), Going(blue), Prize Money(yellow), Distance(grey), Number Of Runners(brown). the text in bracket is a key for the info for your ease of use.

View 3 Replies View Related

Split The Individual Dimensions Into Seperate Columns

Jul 20, 2009

I have a lot of carton dimensions that are always presented in the same manner and would like to be able to split the individual dimensions into seperate columns.
The format is always: Length Width Height. Presentation of data is always ???x???x??? or ??x??x??? (ie two or three chrs seperated by the letter X). If the full string is stored in column A I would like B to display Length, C the Width and D the Height. I find it easy to use LEFT for Length but struggling with Width and Height which I'm sure are easy, just can't get my head around it.

View 4 Replies View Related

Finding Duplicates Adding Them To Another Sheet

Apr 1, 2009

Hello everyone....

I have a project where I need items for different boxes.

i have 20 boxes that need the same amount of items. However, when I came towards the end, i ran out of items.
For example




I have all in a spreadsheet all the items that are missing per box. Here comes the main question....
How do I program my spreadsheet find the items that are missing in each box and summarize in another sheet?

The summary I am looking for is....

and so on...

I started doing the code, but I haven't got too far.

View 4 Replies View Related

Finding Character Duplicates In Two Lists

Jul 19, 2012

I have two lists of numbers.

The first list contains site numbers of people who havent responded to me.

The second list is the master list of site numbers along with a column showing the date they responded.

Now, a site number is built like this:


So it is possible for the same 6 digits to appear more than once in the master list.

What I need to do is to compare the first 6 digits in the non responder list against the master list, because some sites, like the example above, may have more than one '0001' tag and so if they have responded to me from site '0002' I dont want to spam their other sites with emails.

I've tried using match and various formulas I've found from google etc, but nothing seems to work!

The goal of this is to get a list of non respondents that have not responded from any of their sites listed in the master list.

Non Responses

Master List
Date of Response




View 3 Replies View Related

Finding Duplicates And Keeping Them With Totals?

Apr 8, 2013

I have a database with ~18000 rows and 29 columns. I would like to filter the data by duplicates in one column, based on total, but keep the remaining data in the row. For example: I have account numbers listed in one column, often duplicates. I can get the total in a pivot table no problem, but need the other data associated with that account. I do not need to see all accounts, only duplicates for accounts listed say greater than 5 times. The data in columns B+ are important.

I have a HUGE vlookup I created to paste in the pivot table data (account numbers and totals) to run a look-up based on those numbers, but I see that running into problems when you run 4k+ look-ups.

I want to see accounts listed only 5+ times, include that total (as in a pivot table) and the remaining 28 columns. I have tried to run this in a pivot table completely, but still too much data to process (plus all the subtotals that I have to keep removing).

View 1 Replies View Related

Finding Duplicates Using Countif Or Similar

Jan 13, 2014

I have over 400 thousand rows in my data-set and I'm trying to find duplicates using a countif or similar formula. Let's say I have the following:


I need the formula to increment the count. So for example, the first time Blue appears, it equals 1, the second it appears, it equals 2, third time is 3 and so on.

And, I need it to actually work with 400 thousand rows. I have tried using the following formulas without success as Excel keeps crashing:


That second one equals "2" if there's more than 1, which will work for me as well. Better would be if it increments though.

The purpose of having a count is so that I can pivot the data, then filter out all the "1"s and report on it. Therefore I can't use conditional formatting, or simply using Excels Remove Duplicates feature. I need the same data-set for other pivots and charts.

View 8 Replies View Related

Flag Cells Not Common Between 2 Columns In Seperate Files

Aug 16, 2008

I'm glad founding this great forum. I have learned a lot in the last few months.
Now I need to do a task and can't find online a tutorial for this. Here is what I need:

File A contains 23 columns with info for 300 products (rows). File B contains same columns for 280 out of the 300 products from file A, plus 40 new products.

I need to flag in file A the 20 products that are not in the file B, plus flag in file B the 40 products that are not in the file A.

The structure, columns, etc are the same for both files.

View 6 Replies View Related

Finding Duplicates - Variation On Previous Threads

Jul 9, 2013

I have a list of text values in column X. I need to come up with a formula in column Y.

First HAT in column


I can't play about with the natural order of the spreadsheet, so there's no chance I can re-sort the data into column X and (easily) identify the duplicates that way. So, it could be that the duplicated value(s) will appear in any cell within that column.

I need to identify whether the item is a duplicate in the unsorted list. Ideally, the first entry of a set of duplicates will be given 1, then the subsequent duplicates themselves given a 0 (zero). It's to subsequently do some counts on.

I guess that as long as the one of the entries in the duplicates is marked with a 1, while the others are 0 (zero), that's all that's important.

View 3 Replies View Related

Finding Duplicates And Highlight Enteries In A Roster

Sep 4, 2008

I have a roster for a large group in excel and would like to have an easy way to highlight if there are duplicate entries in the roster as we are merging multiple smaller lists together.

View 9 Replies View Related

Finding Duplicates :: Find Duplicate Cells In A Column

Apr 16, 2007

I have many rows of data. How can I find duplicate cells in a column?

View 9 Replies View Related

Finding Duplicates (cell At The Top Show Row Number Of Duplicate)?

Mar 3, 2008

i have duplicate cell entries occuring. I have a column of about 8000 entries (Column B) and would like to have a cell at the top of my spreadsheet that displays where the first duplicate resides (Row No. will suffice).

At present i have a conditional format on dupllicates, but is is a big task to scroll down through all the data looking for them.

View 9 Replies View Related

Macro To Compare Columns A & B And Dispaly Any Duplicates In Columns C & D

Feb 21, 2009

what I'm after is a macro to check the contents of Column 'A' against column 'B' and display any duplicates in Columns 'C' & 'D'.

N.B. The headings of Columns C & D are :-

C = Value Found in Column A

D = Value Found in Column B

Any duplicate entries logged in columns C & D should be listed in C2,C3,C4....C20 and D2,D3,D4......D20 etc (in effect creating two new lists)

View 5 Replies View Related

Move From Seperate Columns On Sheet2 To One Column With Forward Slashes "/" Between Sheet3

Jan 11, 2010

I have three columns (9, 10, & 11); text, currency, and text and I am trying to move them from seperate columns on Sheet2 to one column with forward slashes "/" between them on Sheet3. The attached code does this, however I lose the dollar sign and commas.

View 4 Replies View Related

Vlookup - Finding Additional Values From Duplicates Using Additional Column

Jan 29, 2014

I am using a spreadsheet as a score sheet for a competition. One of the columns is the student's GPA. After entering all the scores there are duplicate final scores. I need a way to have it look at the final score and then use the GPA so that it will not put a duplicate value in the final column.

al Column N is the Total Column, Column O has the Names that correspond to the Total Column. Currently I am taking this total and putting it into Column Q (High Scores) in high to low order. Column R should have the names that match the scores. But with duplicate scores, it is only putting the first name associated with the score. I would like to use the GPA as a final determining factor for the duplicate scores. The higher GPA would come before a lower GPA. I have tried to put an additional column to bring the GPA over to correspond with the High Scores Column, but could not get it to work.There are actually more names for the competition and the top 10 will be moved to a different sheet and further judged. I have attached a sample with the exact formulas that I am using.

View 1 Replies View Related

Duplicates In Two Columns?

Sep 27, 2011

I have two columns of data, I and M and need to find the cases where duplicates occure in I but the data in M does not match. If the data in M matches then it's ok. I have column I sorted A to Z.

View 1 Replies View Related

Duplicates In Two Columns

Feb 21, 2009

I have a list of numbers in column A of my Worksheet, and a list of names in column B.
There are duplicates in both columns:

234 John Smith
253 Charles White
461 Mary Carlsson
876 Erica Alvin
954 Joe Brown
234 John Smith
461 Mary Carlsson

The duplicates in column A and in column B are correct, because the same names correspond to the same numbers. I would like a formula or VBA macro, if possible, to detect when there is no correspondence, for example, if the last row above were

461 Ben Wayne - where it should be Mary Carlsson.

Is it possible to check all the rows of both columns and identify errors?

View 9 Replies View Related

Copyrights 2005-15, All rights reserved