differences

Hi everyone, I hope you are well. I have a spreadsheet that evolves every week. I used Power Query and imported the workbooks produced the past weeks, basically copying the query and simply modifying the source. Is there a way to remove alla common data (what remains unchanged basically) and...

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

<!--[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...