1. R

    Compare two files and highlight differences

    Hello, I need to compare two files (File A and FIle B) and highlight the differences (in File A). The two Files may have different columns but I only want to compare two of the columns with the same name. See below for Column info: Identification Number...
  2. W

    VBA find differences in 2 worksheets

    I have two large worksheets. One was run a couple months ago and the other was run this week. I'm looking for VBA to find the differences between the worksheets. Each worksheet is set up the same, but the data may not be in the same order, and may not have the exact same items. Spreadsheets...
  3. R

    Copy to cell after comparing between two columns data

    Column N Column P Column R Housing#VALUEDargon 1 1 2 2 ... ... .. Hi guys, I'm exploring how to compare data contained in the same row between two columns, then copy to Column C for cell values that don't contain #VALUE in it using VBA and run it all the...
  4. T

    Copying unique values (between columns A and B) from column A to Last Row+1 of column B

    Hi everyone! I'm looking to compare two columns on 2 different files. Let's call them Column 1A (File 1, always has the same file name and directory) and Column 2A (File 2, shares directory with File 1). I want to extract the unique values from Column 1A that are not present in Column 2A and...
  5. N

    Vba code to compare columns in different sheets

    HI Friends , I'm looking for a little help in Vba macro. I have two sheets ( category ) which has values like CURRENT ASSETS ,NON CURRENT ASSETS, CURRENT LIABILITIES ,NON CURRENT LIABILITIES , PROFIT LOSS Etc.. in the other sheet (Balance sheet) in column A i have CURRENT ASSETS ,NON...
  6. F

    VBA comparing Cells

    Need help with this. Looked through some similar posts but couldnt figure out how to adapt them. I got a value in cell B2 and a value in Cell B1 (a value between 0-10). They are values that are not allowed to be the same. If the value in B2 ends up to be the same as in cell B1 i need to call...
  7. nareshmedarmatila

    Need to compare two Sheets using Macro

    Hello All, I need a big favor regarding a work I need to compare sheet1 which consists old data and Sheet2 Which consists Some new data or edited one I need to compare two sheets and need to highlight or need to cross check which is same and Different. I don't know how to wirte vba code so...
  8. D

    Compare specific Column in two sheets and append data to last available row

    Hello, I am fairly new to vba and i am having a hard time coding something that will solve my issue :( I have two data sources I wish to combine. Sheet 1 Data source on Sheet1 contains 2 columns: AccountID and Cost. Source is in cells A3:B3 (data row starts in A4) for 1 to N records. A...
  9. T

    Compare 2 columns and one of them has partial value of the other

    I have a macro that compares the column of a table with the column of another (both are extracted from an application), and returns me which values do not exist in both. However, the Table4[MSG_DESCRIPTION] column has a limit of 50 characters, and the Table3[Title] column has 500 characters. I...
  10. S

    Compare 2 VBA projects

    Hello friends, I am doing various updates on more than one "workbook". I forget some of the updates I made when it came to order. Is there an application that compares "workbooks" to prevent this? vba page is quite limited, i can't even open two codes side by side on the same page. What is...
  11. M

    Vlookup when multiple same value in both columns

    I want to vlookup with supplier and product with other file "Comparing file" which has supplier and product. if value matches and status is completed , Mark as Yes in output Supplier Product Status Output AB XY-1 Completed Yes AB XY-1 Completed Yes AB XY-2 Completed Yes BC ZA-1...
  12. H

    Compare 2 Cells With Numbers Which Have A Seperator

    I have 2 columns of data, Y & Z; they are times of goals scored. I want to create a column which will compare the data in those 2 columns and tell me whether the Home or Away team scored first. The issue I have is that many games do not simply have 1 goal, or 1 goal from each team. Often one...
  13. T

    Compare Two Delimited Lists and Determine if Values are the Same

    Hello, I am trying to come up with a function that compares two delimited lists to see if they are made up of the same values. Each list is in its own cell, can be variable length, and can have variable order. I'll give a few examples of inputs and outputs to display what I am trying to...
  14. tourless

    Finding text, comparing values, and adding to existing

    Hi Folks, I have two sheets, 'Details' (contains invoice line items) and 'Summary' (contains invoice totals only. Both sheets contain values starting at row 6 and have intermittent spaces between sets of values. Details is separated by invoice numbers in column C and Summary is separated by...
  15. Johnny Thunder

    Formula Help: Need to combine two CountIF's within a IF/AND Statement

    Hi, I am working with a formula that I am getting some weird results and hopin someone has a solution. I have two Concatenate formulas that combine about 3 Columns of data, These formulas are in Col J:K. I then have two other columns that individually look at each concatenate formula nand...
  16. Y

    compare and find prize through prefix

    Hi guys I was wondering if someone could help me with this challenage. I am looking for a formula to calculate a prize based on the prefix (telephonenumber breakout). These breakouts are to call international. See below the prefix and rate example template. It works like this, if the prefix is...
  17. R

    Compare Dates in Various Columns

    Hi There, How can I check to see if all rows in columns A, B, and C have the same dates and spot the rows where the dates are different in these columns? Thanks.
  18. F

    Lottery verification

    I have an excel program where I count the numbers for the past year then use the count to pick my lottery numbers. I have won small amounts for the past year every week but never amounts over $100 so now I would like to refine my program to look at the past years drawings and compare it to my...
  19. S

    Compare each cell of a row with another row from another excel file

    So, hey people. Thank you for reading this and for putting some thought into it. I have a long line in an excel file, let's call it X, that I need to compare it with another line from another excel file, we'll call it Y. The thing is that the Y line has the same first 6 cells as the X one...
  20. R

    Array compare?

    I have a project (proprietary, can't go into details, sorry) where I read in data from a server and convert it to a user friendly graphical form. It get's repeated over time and sometimes the source data will slightly change from what was previoulsy imported. My users have asked for me to do a...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back