compare 2 columns

Hi folks. I have some working code here but it is very slow. Could anyone suggest a faster alternative? I did try using the dictionary but eventually gave up. It was the passing of the dictionary to and from the sub while also passing the sheet name that was causing the problems. I think perhaps...

Hi all, I'm faced with an interesting data validation challenge from my manager, the typical (manual) process would be to compare 2 workbooks comparing ID numbers, and if the information in another column has changed. If there was a change it would be copied to another workbook (I know 3 books...

Hi, I'm trying to use multiple COUNTIF to check two sets of criteria. I have a list of ID’s who have a specific fruit for each day of the week. What I need is for the ID and fruit columns to be compared, with the following criteria If duplicate IDs are found and the same fruit on both days it...

Hello! I'm very fresh to this and trying to learn but i'm having real issues trying to get this to work. I've tried multiple "countifs" and "if(sum"s and i'm getting nowhere. I'm looking to see if ANY text in F range is the same as ANY in the H range, If so return true, otherwise false...

How do I compare and combine two columns? Column A has a list of business email addresses. Column B has a list of personal email addresses. I want to compare column A and B and put in column C the value from column A if they match. If they do not match, put into column C what is contained...

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

I am looking to compare two columns A & B and find if there are any sub-strings that are the same & Infill column C either with the same text or 1 if it matches - whichever is easier <tbody> Col A Col B Col C Alt Col C R5 201F35 030` 020` 712 0 0 R6 NFL1006235` 1001 1001 1001 1...

Hello there! So I'm trying to create a query in Access that will have a calculated column that compares the first 2 columns and return True if the first column number is less than the 2nd column number. how would i go about doing this? tricky thing is, the first 2 column headings change based...

Hello, I have a datasheet with 35000 datas in one column and I have to compare it with another colomn that contain 10-15 lines. The problem is that the way they are written are not the same. For example in one column I have : Microsoft Visual C++ 2008 Redistributable - x86...

Hello I am trying to find a string in Column D and Column H and if they match certain criteria, insert the string "Match" in Column W. For example, if the string "Auditorium" occurs in Column D and the string "INTERNAL" occurs in Column H on the same row, insert the string "Match" in Column...

Hello! I am trying to accomplish a task in Excel to avoid multiple "messy" manual steps. This is a simplified version of my workbook: <tbody> Employee Item No. Description Pack Size Color Quantity Year Amy 1111 Item 1 6 10 Red 450 2016 Amy 1111 Item 1 6 10 Red 300 2017 Amy 1112 Item 2...

Hi there, I am in the the process of trying to find out (in the form of a formula so that i can have the number on another sheet) how many X's in column A there are when i am specifically looking at the Y's in column B. every cell in these columns has a drop down option that has been linked...

I wanted to compare the alphabets with 4 columns for every 4 rows. For example, A = [aabc;dbba;a] B = [aabc;baba;c] C = [aabc;dbba;b] D = [bcac;bcbc;a] ABCD are the columns. If we look at the table above shows first four rows, "aabc" repeated in 3 columns. So, out of 4, 3 gets correct...

Hi, I have spent a few hours trying to find a solution for this but feel the time is now right to ask for help! I have a spreadsheet with address details in column A for around 100 of our company sites. In column B I have address details of all the properties our company visits, which includes...

Hi I am attempting to compare 2 columns in separate workbooks, and if a match is found, to return the data in columns 38-40 from one workbook into columns 38-40 of the second workbook. I thought the best way to do this was to progressively loop through the values of the column in WB1, and...

Hey all, I have a table that contains a list of reservations and a table that contains a list of "BOMS" (bill of materials). I would like to count the number of times a BOM shows up in the reservation table in a specific fiscal year. An example of each table: <tbody> BOMID FY2010 FY2011 1...

I'm trying to compare how water use for a company changed year over year. My data set currently looks like this (with 893 rows): <tbody> Name 2011 Water 2011 Name 2014 Water 2014 Company A 110 Company C 100 Company C 90 Company B 90 Company B 50 Company D 80 Company D 40 Company A 70...

I have two excel columns side by side "original" and "edited". In a separate column I want to compare the edited column with the original column, with new text coloured green and removed text coloured red and stuck through For example: <tbody> Original Edited Comparison The cow...

Hi! I desperately need your help! I am very new to VBA, but need this code urgently... I have a workbook with 2 sheets, one is a list of deliveries with 10 columns and endless number of rows (Sheet1) , which is filled by the company, and another with 23 columns and even more rows than in the...

Dear friends, i want to compare two columns and identify the values that are equal. column A Column B 12345 ------------12345 1000 2000 -------1234 3000 -------------6000 9000 If i use formatting, i can...