compare

Hi guys I was wondering if someone could help me with this challenage. I am looking for a formula to calculate a prize based on the prefix (telephonenumber breakout). These breakouts are to call international. See below the prefix and rate example template. It works like this, if the prefix is...

Hi There, How can I check to see if all rows in columns A, B, and C have the same dates and spot the rows where the dates are different in these columns? Thanks.

I have an excel program where I count the numbers for the past year then use the count to pick my lottery numbers. I have won small amounts for the past year every week but never amounts over $100 so now I would like to refine my program to look at the past years drawings and compare it to my...

So, hey people. Thank you for reading this and for putting some thought into it. I have a long line in an excel file, let's call it X, that I need to compare it with another line from another excel file, we'll call it Y. The thing is that the Y line has the same first 6 cells as the X one...

I have a project (proprietary, can't go into details, sorry) where I read in data from a server and convert it to a user friendly graphical form. It get's repeated over time and sometimes the source data will slightly change from what was previoulsy imported. My users have asked for me to do a...

I have data somethins like this a b c 1 1 1 1 2 1 1 2 3 1 2 1 4 1 2 2 5 2 1 1 6 2 1 2 7 2 2 1 8 2 2 2 I have excel formula which...

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