differences

  1. A

    Comparing Two Columns with VBA - accounting for no differences

    Hi, I have a macro that is able to find differences between two columns that are side by side and then spits out the differences onto another sheet. The macro works well when there are differences, but if the two columns are the same, then I get a 400 error. What do I need to do so that my code...
  2. P

    Compare three columns between two spreadsheets and display differences in a third spreadsheet

    Hi everyone! I am working on a workbook where I want to create a macro to compare the differences between two spreadsheets that have three columns of 1000's of data. That's three columns of data in one spreadsheet and three in the other. I may not be explaining the best way to do this, but...
  3. E

    How to find differences between rows and add those differences. (VBA solutions welcomed!)

    <tbody> <tbody> ID number </tbody> <tbody> Fruits </tbody> <tbody> id100 </tbody> <tbody> Banana, Strawberry, Melon, Apple </tbody> <tbody> id100 </tbody> <tbody> Banana, Strawberry, Apple, Carrot, Broccoli </tbody> </tbody> Hi, I'm trying to find all 'ID...
  4. C

    Comparing Differences Between Entries based on Two Other Columns

    So I've got a complicated spreadsheet. Column A is a name. Column E is a field saying "first" "second" "third", etc, based on the number of interactions we do with that person. Column K is a numerical points value. Some people from Column A have multiple interactions with us, and each one is...
  5. A

    Compare 2 Worksheets and Copy Only the Differences

    Relatively new to VBA (so labels help a lot), thanks! I am trying to create a macro to track monthly changes in costs. A unique key requires columns D, F and J (community, plan and option). If there is a difference in column Q I would like to copy it to a third sheet. If a row has been added or...
  6. A

    Compare the values of 2 columns and copy their defferences

    hello! I've been trying to resolve this but I can't finish it! I have two workbooks, "Guides.xls" (workbook 1) and "Provider Guides.xls" (workbook 2). They have a lot of information but I only care the column with the numbers of guides and they can be in any column in the workbooks. Is...
  7. M

    Conditional Formatting - Column Differences

    Hi there, I am trying to create a conditional formatting in Excel 2003 in a single column to locate and highlight the values/formulae that is different than the others in that very column. For example: Column D summs all values in range A:C as below: D1 = SUM(A1:C1) D2 = (SUM(A2:C2)+10) D3 =...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top