1. Johnny Thunder

    Formula Help: Need to combine two CountIF's within a IF/AND Statement

    Hi, I am working with a formula that I am getting some weird results and hopin someone has a solution. I have two Concatenate formulas that combine about 3 Columns of data, These formulas are in Col J:K. I then have two other columns that individually look at each concatenate formula nand...
  2. Y

    compare and find prize through prefix

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

    Compare Dates in Various Columns

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

    Lottery verification

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

    Compare each cell of a row with another row from another excel file

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

    Array compare?

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

    compare current column with previous column

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

    VBA - Comparing two sheets and placing the difference on the second sheet

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

    Compare two dates - Return an "expired" comment

    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".
  10. N

    list missing people from a list

    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.
  11. 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.
  12. B

    Compare Columns and Delete Emails from a ROW

    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|
  13. kelly mort

    VBA code to compare contents of two textboxes

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

    Compare multiple column using dictionary VBA

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

    Data Matching Names from One Spreadsheet to Another

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

    Compare two columns without highlighting (CF) same data

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

    Compare cell values in same column

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

    compare two columns and output to new column

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

    Compare 2 sheets multiple rows

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

    Row Data Compare

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

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...