compare 2 cells

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

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

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

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

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

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

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

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

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

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

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

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