compare

Hello Once Again. I've been working on a project that I previously posted here. Looking at it from another angle, I think I found a solution where-in I need help. Here is the code I am Using Sub SheetCompare() Sheets(6).Activate '6 is the main sheet 'Cells.Clear 'and clear...

I am trying to compare the date in D4 with date in N4. If date in D4 is greater than N4, I want a comment "Expired".

I have a group of 10 people doing 5 roles in a spreadsheet. I would like a cell to contain the five people NOT doing a role. So the formula would check the five cells, compare with a reference containing all ten initials, and list the initials of people not in a role.

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 I have an excel sheet with two columns Column 1 - is OLD Column 2 - is NEW I would like to compare the NEW email with emails in OLD column, and if it found in OLD data then remove it in New column Example as this <tbody> OLD NEW Result xyz@bbec.com abc@gmaa.com|cde@dca.com...

Private Sub CommandButton1_Click() Dim arr(1 To 2) As Variant, word As Variant If Len(Me.TextBox1.Text) And Len(Me.TextBox2.Text) Then arr(1) = Split(Me.TextBox1, " ") arr(2) = Split(Me.TextBox2, " ") For Each word In arr(1) If...

Hi everybody, I am hoping someone might be able to help with this problem I have 5 columns in sheet1 column A have all the names of employee that attendant today Column B have the names of all employees of department 1 Column C have the names of all employees of department 2 and so on till...

I am trying to do a data matching activity and I'm having difficulty figuring out how to do it. I have two spreadsheets. Sheet1 has the columns LastName, FirstName, Birthdate, and Score. Sheet2 also has LastName, FirstName, Birthdate, and Score, but the Score is blank. There are a lot of...

Sorry that title is vague, I have a project where I am comparing Column D with Column J, Easy enough with standard CF rules, but I only wish to highlight the duplicates between column D and J, I am not concerned with/if there are duplicates with in each column (D or J) just if there are...

Would someone be able to suggest a way to compare values in a column and if the value is the same but as a negative, then highlight the cell or even row. I thought of using a macro with Match, but I am not sure that would work in this case.

I am trying to compare an address on sheet A with an address on sheet B and if they match put data from column E on sheet 2 into column H on sheet 1. Here is the formula I have that is not working. =VLOOKUP(F2,ActiveCustomerListing!$D$2:$E$36000,3,0) Column F on sheet 1 is an address Column D...

Hey there, I have 2 Excel sheets (2000 and 90000 rows) , they both have the same data: first name, last name, gender, date of birth and Id. How do I compare to see if the combination of data match and eventually highlight the difference? I tried to concatenate the values and then used vlookup...

Hello Friends, I want to compare two subsequent rows and highlight all the differences. Example - Treat source A row as the correct data. If source B row data mismatches source A row, highlight it automatically as shown. There are about 60 values to compare (62 columns) and about 20,000 rows in...

Hello, I have this problem, I have a excel work sheet that contains processes. There are some process with the same name inside the same column “F” which want to compare, because some of them are repeated in other rows. However, the other cells contain different data. What I want to do is to...

Hello, I have this problem, I have a excel work sheet that contains processes. There are some process with the same name inside the same column “F” which want to compare, because some of them are repeated in other rows. However, the other cells contain different data. What I want to do is to...

Hello everyone, First of all I´d like to thank all participants on this website, which help me a lot to improve my VBA skills. I hope to get help with my issue :smile: Don´t get shocked about my long text, the main work is done and works. So, Two workbooks 1 =...

In cell j2 need to compare h2 and c2 to o2 and r2, if they are the same then j2 = c2, otherwise j2=c2. Thanks

Hey everyone! This is my first time posting here :) I've been scrolling through the forum for a solution to my problem but none seems to work! I've just recently started doing macros and I have a macro that would compare two excel sheets Col A(Sheet 1 and Sheet 2) and output the new data found...

I have written a piece of code that asks the user to open one text file and it loads it into an Excel sheet. Then asks for a second text file which it loads into another sheet. Then runs through the second sheet to find corresponding records and when it does it compares a column of data. This...

Hi folks, I have 2 pieces of data that are both amalgamations of data from other sheets on the same workbook in the following way: =A1&"/"&B1&"/"&C1 The data is: A1 FOC01/FOCAL POINT/C and B1 FOC01/Focal Point /C The difference being the extra space in B1 This is just a sample of the data...