compare columns

  1. D

    Compare Columns to find Duplicates

    Hello all, I have a list with names of individuals and repeat addresses. I would like to find a way Duplicates. Thanks in advance. <tbody> 1 A B C 2 John Smith 2 Main St Apt 5B Duplicate 3 John Smith 2 Main St Apt 5B Duplicate 4 Jason Bourne 5 Rock Road Apt 2B Not Duplicate 5 Jason...
  2. C

    VBA tool to create template to spot and highlight differences between two spreadsheets

    Hello, I have a VBA problem that i need help with. Scenario: We constantly receive spreadsheets from third parties which we use to record various metrics. The problem is that these spreadsheets are supposed to have the same headings and format to fit our set template but do not. It takes time...
  3. D

    compare columns

    Hi, i need to compare two columns for differences and highlight them; the columns may contain duplicate data. As example, for the below two columns, DWB931 on column A and DWD966 from column B should be highlighted. Note that there is one DWD966 in column A but two in column B. i need to do this...
  4. M

    Compare two sets of columns and eliminate exact mactches

    Hi All I am a newbie here :warning: so please bare with me. I am trying to recon two sets of data both of which has two columns of info. I need excel/access to find the exact matches of the two sets of columns and to remove them leaving me with unique info for both the data sets as seen below...
  5. P

    Compare columns in 2 sheets

    How can I figure out what is in column A of sheet 2 that doesn't exist in column A of sheet 1.
  6. H

    Comparing Columns inserting message based off of difference

    Hello again! This community has been so helpful with my previous problems I've returned with another. This could be something simple; however, I can't seem to figure it out. I stole this code (off this site?) and I'm trying to re-work it to compare two columns based off of the position of...
  7. E

    Compare Columns and divide

    Hello people, I need help with a code does following: loops through Column J and K if the values(text) are equal on the same row select the Value in Column B and (same row) divided by the value in Column AB (same row) and present the new value -1 in the Column T and if there is no value in...
  8. J

    Comparison of Data between Worksheets Same Workbook

    I'm not an excel power user by any means, so i'm having trouble getting a column in one worksheet to compare against the same column in another worksheet. I have two different worksheets in the same workbook each sheet contains a different data with the exception of one column. The columns...
  9. P

    How show differences and count between 2 columns of text???

    Have Excel 2003. Need some help from you kind more experienced folks. I have done some research but just have not found exactly what I am looking for. I have a list of email addresses in column a List of email addresses in column b. ** I would like a formula that will take all the values in...
  10. J

    Conditional Formatting on two columns to ignore *

    Hi I'd like to compare two columns of data and highlight where a value doesn't occurr in both columns. The problem I have is that one of the columns uses * around the text to ensure it catches all variations of the value. I have the following formula which would work if the data was exactly...
  11. S

    Comparing two columns in two different open worksheets

    Sometime back, I had posted a request on the above subject but there was a mistake in the same, as a result of which I did not receive any reply. I am posting the corrected thread again and request the member to help me out with my problem. I have two files, of which File1.xls is a master file...
  12. S

    Comparing two columns in two different open worksheets

    I have two worksheets, of which Namelist.xls is a master file and the other one is named Namelistanddata.xls. Namelist.xls has 3 columns. Column B is titled "names" and there are 300 names. Namelistanddata.xls has columns A:P, with column D titled "names" having 5000 "names" and these 5000...
  13. S

    update contents of column by comparing two other columns

    Hi, I need help with trying to perform the following opearation in excel: I need to update the prices of items in my inventory when my supplier gives me sends me a new pricelist. I need to build a macro I believe that will compare Item Codes in My Pricelist with Item Codes in New Pricelist and...
  14. J

    trying to create vba that extracts names and compares them

    Hey all, I'm having a little difficulty with a vba macro I am creating in excel. Basically, item in column A may also appear in column B. I want the one with the greatest length in column C (In other words, Jennifer T Tamashiro is the same person as Tamashiro, Jennifer but since the first has...
  15. D

    Compare % difference 2 columns in a PT

    Hi I have an Excel 2010 Pivot table . I want to compare the % difference between customer sales in 2009 and 2008. I have 3 columns at present Customer name ,Sales 2009 and Sales 2008. I would like a fourth column to show the % difference .Can someone assist me by outlining the process to do...
  16. I

    Is there a macro/add-in to allow partial text filtering using one column to filter another?

    How do you write a macro, script or conditional formatting (or is there an add-in I can buy) that will use a partial text match from cells in one column (column J), to filter the list of phrases in another column (Column A). I found a formula that lets me filter column A by just one cell in...
  17. R

    Delteing data in Col A if "ABC" found in Col B

    I need to look for "ABC" in col B and if found, delete cell data for that row in Col A. Can you assist in how to do this. I have over 20K rows to review and would like a systemic way to accomplaish this. thanks in advance RT
  18. H

    easy thing getting the best of me

    I have a list of 400 school names in col. A and a list of 110 "done" names in col B, I want to find out what schools are "Not Done" by comparing the 2 columns and sticking the results in a new column. easy enough right, what am i missing?? everything i tried came out wrong.
  19. D

    Compare and Delete

    Dataset 1 Workbook 1 (name varies)--> Worksheet 1 --> Column A --> Cell 2 thru (varies - can be hundreds or thousands) Dataset 2 Workbook 2 (Rlistsort) --> Worksheet 1 --> Column A --> Cell 2 thru (currently 250 but will continue to increase) Need to compare Column data in Workbook 1 to Data...

Some videos you may like

This Week's Hot Topics

Top