comparing

1. Updating values and highlight them based on external excel file

Hey guys I have two versions of the same files. One of them is the updated one with the new data. Now I have troubles writing a macro which does the following: Ask which file I want to compare it to. Comparing two identification numbers in those two different files. If they match, it shall...
2. Comparing two arrays and go to if-condition if match was found

Hello, I have two arrays Arr1 and Arr2 that both include a list of words. I need a code that compares every element of Arr1 with every element of Arr2. If at least one match was found I wan't to add more code. So it would look like this: If Arr1=Arr2 Then ... The comparing part is not working...
3. Double Negative and If statements

I have the following formula in cell A13 IF(AND(H6>0,J8<-0.02,L6>-0.02),"MANAGEMENT SIGN-OFF IS NEEDED",""). If the value of J8 is -.01 the true statement appears but -.01 is not less than -.02. I know it has to do with comparing double negatives. The problem is sometime the result in J8...
4. Comparing two date cells

Hi I have a date in K (11/11/2019 17:20:35) and a date in D (11/11/2019) I want to calculate if D was after or not on K. My formula is =IF(K1<=D1,"yes","no") This seems to work, expect in this example, where the dates are the same. Because the time is also in K, is doesn't see it as a...
5. Comparing Arrays

Hi, I have two arrays that contain a date, amount and description. I need to compare the two arrays and then process the differences. Possibly place the contents in another array so they can be processed or output them into a sheet. Thanks
6. Complex Distance Formula

Hi, I am trying to find the nearest distance between many points. I have a set of about 300 coordinates that I am comparing to a list of about 4k coordinates. I am using the formula...
7. Formula to search for most previous match?

I'm setting up a spreadsheet to display monitoring data in the form of X, Y and Z coordinates. I want to be able to show the relative and cumulative differences between measurements. The formula for the relative difference is just comparing it to the cell above, whilst the cumulative is...
8. Comparing columns -> Grouping

Hi there, I've built a Chi square test and a column proportion test in Excel and am now trying to build a grouping of the results. I've started off with this example: https://www.ibm.com/support/knowledgecenter/en/SSLVMB_23.0.0/spss/tables/sig_tests_colprop_ex.html#sig_tests_colprop_ex The...
9. Comparing 2 Lists and using Vlookups with multiple rows.

https://drive.google.com/open?id=1TfqRi0g6FwDCY0iNOfVWOyLhAXgBPygR I'm trying to write a VBA sub to look up the value of two references on different sheets. The problem I've got is the value being looked up has entries in more than one row which I believe is difficult for this command. I was...
10. Excel - Comparing Cells and Identifying Differences in Pivot Table

Hi All, have been trying this for hours with no luck. Can you someone provide me a VBA code that will help with my issue? To set the background: I have a set of data, firstly I need the macro to insert a Row between the 3rd/4th row and then every 2 lines after. So in my data create a row...
11. Comparing Two Lists of Data

So I have two lists of data that I need to compare. How would I go about comparing these two lists for matches and unique values? Should I use a Vlookup or Index match match? or is conditional formatting the best way to accomplish this task? Thanks!
12. VBA OFFICE 365 verses other versions

I am running office 365. I recorded a macro with a simple sort command. It ran fine on my machine. Crashed on machines using Office 10 Comparing the code I found only one difference. Add2 vs Add Have they changed VBA in the new version?
13. Type Mismatch Error When Comparing Ranges

I have the following code and get a type mismatch error when comparing two ranges through a loop. When comparing the rows, the first column has a number and the other three contain strings. The idea is to find any differences between the two sheets and put them into another sheet. I changed...
14. Two Sheets Two Column Comparing

Hi All After searching a lot , I did not find any solution here and on web, Actual I would like to compare sheet1 a col with sheet2 a col and copy result on sheet "Comparing Result" both comparing sheets several duplicate values, I don't want to remove duplicates values when copying result ...
15. CountIfs to see how many Dated in Column N are greater than Column M

I have multiple criteria and the last one is comparing two columns with dates. Here is what I have so far: =COUNTIFS('eMail Tracker'!A:A,"<>",'eMail Tracker'!K:K,"",'eMail Tracker'!O:O,">" & NOW()-1,'eMail Tracker'!M:M,"<" & 'eMail Tracker'!N:N) This checks for: Column A is not blank Column K...
16. Excel IF Then across a row instead of a column

I need to compare select items in a column per row. For now,I need to compare each row one at a time because of how the spreadsheets are set up. for instance, in cell C808, compare value I C 2 against C3, if same ^, "error, for cell E808, same logic. as I change the row number (C808 to...
17. Comparing Pivot Tables

OK, so my task is to write a 'tool' that the user can specify the location of two workbooks in a specific format. The first was the 'original' run (1), the second the same but at an 'updated position' (2), so improvements due to data cleansing etc. Each workbook with have the same tabs, and on...
18. Comparison of two sheets.

Hello All, I am comparing two sheets. Changes should be saved in the new sheets. If there are any new lines, add, removed, changes I got one information from you tube, however when I try it real time scenario it not working. Please advise if anyone from the forum would be able to help me...
19. Comparing two columns to find out common text

Hi, I have a following serious query and dont know what to do? Please help. I need to display common text by comparing Column A and B and also require to have unique value "ABC123" ........ with the text in Column C. Is there any way to do this? <b>Excel 2010</b><table cellpadding="2.5px"...
20. Comparing And Retrieving Value With Blank Cells

<tbody> Hi, All the expert people out there. I am stuck in a problem and have tried lots of option but no success.I have two sheets in one worksheet and I am comparing 2 columns to retrieve the value from one into another. screenshot attached The problem is that the sheet I am retrieving the...

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.

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

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