1. J

    Conditional Formatting - Highlighting differing values

    Hi all, If I have multiple columns that I'm identifing differences in, and what to highlight those differences. What conditional formatting formula could I use? Example: Columns A2 and B2 should be the same, but they are different values. I want to highlight both cells. This rule would be...
  2. S

    VBA Differences

    if r =("A1:M1") then I know what this would do For each c in r But what would be the difference between the following below: For each c in r.rows For each c in r.cells For each c in r.columns
  3. K

    Compare 2 columns in one worksheet to another

    I have a file with over 100K rows and was wondering if there is a quick way to compare columns C and D in Previous Month to Current Month and vice-versa then output differences to Differences worksheet.
  4. T

    Compare 2 data sets and identify differences using Pivot / Conditional formatting (or another method ?)

    Hi All, I am looking to compare 2 data sets and identify any differences using colour. I have demand from a customer and want to compare against an internal demand book. I have created data set to test this. I have added 2 data sets into a simple table with one column identifying data source...
  5. K

    Macro for determining differences within same spreadsheet

    I'd like to create a macro that quickly identifies 2 datasets in the same spreadsheet and highlights any differences. I need to reconcile from a different system, so I export that data into my existing spreadsheet. They need to match exactly. I have used conditional formatting successfully...
  6. I

    Are there any differences between these two ways of typing a shortcut?

    Hi guys, If I want to paste something as value, I can press Alt + ESV. That is, hold Alt and press and release e, press and release s, press and release v. It did the trick. However, I just found I can also press Alt and release it, press and release e, press and release s, press and release v...
  7. M

    Workbook-to-Workbook Update with different column names

    If someone could point me in the right direction with a link and/or an example line or two of code, that would be fantastic. I have two workbooks, and a colleague will be updating one of them sporadically. I'd like to create a command button that will update the differences between the two...
  8. T

    Macro to compare columns from different workbooks and provide output

    Is there a macro out there that can compare column from two different workbooks and split out the differences on a sheet. For example: This is on book 1 not on book2 and list the differences. Then underneath that , This is on book 2 not on book 1. So the macro should do the following: Allow...
  9. R

    Comparing multiple Excel Spreadsheets

    Here is what I am trying to do...I have multiple .csv files all with the same information. Column A contains a name and column B contains a value. I will have up to 47 of these files each with about 400 rows. What I am looking to do is compare all of these files to each other and find the...
  10. M

    help with slicer

    Can I get raw data from 2 differences sheet onto a dashboard with only using 1 slicer.
  11. P

    Compare two column

    I have two column in excel I want find column differences ; I have below two column I want to find out based on the employee name check entire Manager column find any differences in manager name. Emp Name Manger Mike John Mike Victor
  12. S

    statistics for "difference in differences"

    I wonder if anyone on this forum knows how to calculate using EXCEL the statistics for "difference in differences". I have 4 sets of groups - each group has a mean and a standard error I am trying to calculate if the difference between group 1 and 2 is the same or not the same (statistically)...
  13. V

    Compare two versions of same workbook and see the difference in same format

    Hi I am trying to compare two versions of same workbook and I also found VBA that is showing cell wise differences of the sheets but it is giving in difference format. How can i see the differences between 2 versions of same workbook in same format. I mean same look like original workbooks...
  14. L

    substitute() vs replace()

    Hi I am reading about the differences between these 2 function (http://www.excel-easy.com/examples/substitute-vs-replace.html). I thought substitude() function can replace the replace() function and no need to use replace() at all. Can you give me one example that I can not do it without using...
  15. J

    Change from Shared Workbook to Coauthoring

    Hi, I have created a shared workbook in Excel 2013 to use as a client manager at work. I have many columns with drop down menus. Sometimes mistakes happen and the data validation for the drop down is removed. This can be fixed by asking everyone to close, un-sharing, copy and paste 'data...
  16. R

    highlighting individual differences

    if in cell 1 I have 1JK3L and cell 2 has 1IK2M, is there a way to just highlight differences, so J3L would be highlighted or something in cell 1 and I2M in cell 2? Thanks
  17. D

    Compare and sort VBA

    Okay I have two sheets in an excel file. Each sheet is from a different database dump that I need to compare and find differences between the two. In a perfect world I'd like to be able to copy and paste the values into the two sheets and have a macro that will sort the two separate sheets first...
  18. T

    Would it be possible to have a macro that can find and list differences between two files?

    Hi Everyone, I don't know if this is possible but it would help me a lot. I often get two files that have started out as the same document but get edited so some data is different. (I know this sounds crazy but it happens and I can not stop it so I have to deal with it.) Both files are set up...
  19. A

    Automatic max of differences between the Max and Min of each row

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi, I have a series of temperature readings (which number of rows and column may greatly vary). Example : <tbody> Time S01 S02...
  20. 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...

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 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