compare 2 cells

  1. SkywardPalm

    Finding and comparing dollar totals calculated from two different sheets to raise a warning if they do not match

    I was curious if I do not need the ElseIf statement, since the If and ElseIf have similar structures and I potentially need to search in more columns if the Current total was not found (shifted to the right due to sub-section values). Maybe there is a more dynamic way of finding the $ total that...
  2. S

    Need formula to compare text in two cells, indicate if they match, not move when corrections are inserted

    HI, Thanks in advance, (-: I have 39000+ rows of data in four columns First name A, Last name A, First Name B, Last Name B. The lists of names are from two different GEDCOM files that need to match but do not match. (I need to see the matches and the mismatches easily, as reference to repair...
  3. B

    Need help: compare two cells for highest number, if text in one of the cell then return N/A

    Need help with the following if B>A result Y, if A>B result N, if text in any of the cell then result is N/A <tbody> A B C (Result) 5 4 N 10 100 Y N/A 10 N/A zero 100 N/A </tbody> <tbody> </tbody> Thank you
  4. K

    Compare 2 adjacent cells and any differences, return in a 3rd cell

    Hi, I hope someone can help me. I have 2 columns on my spread sheet with lists of addresses in them. These addresses are for the same property (in adjacent cells) but sometimes one address has more info in it than the other. If the addresses in either are different to their counterpart, I...
  5. A

    Compare the data

    Hello All, I want to compare two data's. My A-D are main data, F-I are my ref data. I have to check is the reference data have the same value or not. If it dont have it then it should provide correct data. If you see Stephen have the same Fruits in both Main and Ref data. Some thing should...
  6. J

    comparing 3 columns with VBAI

    I need to setup code that compares 3 columns. column C will have comparison values. I am trying to compare column C to D. If column D value is matching C, column F should be greater than 1. If not I would like to prompt user "Please put greater value in column F" and exit out of the code. Is...
  7. A

    Skipping an iteration if there is a mismatch error.

    I have programmed some conditional formatting using VBA, comparing the values of 2 cells in many iterations. The issue is that some of my coworkers do not understand that in order for these numbers to be compared, they must have the same format. Some of them have put words in one of the cells...
  8. R

    partial cell contents matches for names

    Hi All Really need some help or guidance. From a report listing 2000 groups and Manager I need to compare names in each column. Column C would have the result (Match/No match) Obviously column A is a match, column B isn't) Column A company.co.uk/Accounts/Users/Bill Smith...
  9. T

    VBA to compare a date from one sheet to dates on second sheet of multiple similar people?

    I have to match unique ID's using names from one sheet to the other. The problem is the sheet I'm matching to has some people with the same name so when I get the ID it could not be the right one. That's why I need to compare dates of termination and see if they're similar, so I want to go...
  10. S

    Comparing duplicate values, finding MIN, conditional formatting

    I've tried a few methods, but I'm struggling to put them all together to get my exact scenario to work. Any help is greatly appreciated. I have a spreadsheet that needs to search down column B (Rate), find any duplicate values (there will be 12-15 duplicate pairs)-- and compare the values of...
  11. H

    VLOOKUP/comparing adjoining cells in seperate sheets

    I have a workbook with two Sheets (sheet1 and sheet2) that each have 2 columns of data. Column A is a unique ID and column B is a date. I need to do a vlookup for a matching ID in column A and then compare column B values. If sheet2 column b is < sheet1 column b then I need to update sheet1...
  12. M

    Numeric compare fails using cells.value

    I need to compare two workbook sheets. If the rows are identical, I ignore. If the data on the row is different I flag the "New" workbook row as modified. If the row does not exist on the "Old" workbook sheet, I flag the "New" workbook as new. The "Old" is extracted from a Sharepoint Workbook...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top