compare columns

Is it possible to use "Advanced Filter" to compare two columns in the data range and keep if the values are the same? Trying to use Advanced Filter and avoid creating another column of data with which to do my comparison. For example, I want to compare columns M and S and keep the rows where...

I've have come close to solving my original dilemma: Compare Two Sheets (A and B) and copy & hilight differences to bottom of B NOTE: I did try to use XLS2BB add-in and it locks up my EXCEL program. In breaking down my original problem, I have come to this road block: some data is not...

Hello. I have this code that compares two columns between two sheets. It matches the values in column J in “Ships” with column M in “Main”. It copies the value 10 cells to the right from sheet “Ships” and pastes it in the 3rd cell to the right on “Main” sheet. However, I need it to only paste it...

Hello all, I have a list with names of individuals and repeat addresses. I would like to find a way Duplicates. Thanks in advance. <tbody> 1 A B C 2 John Smith 2 Main St Apt 5B Duplicate 3 John Smith 2 Main St Apt 5B Duplicate 4 Jason Bourne 5 Rock Road Apt 2B Not Duplicate 5 Jason...

Hello, I have a VBA problem that i need help with. Scenario: We constantly receive spreadsheets from third parties which we use to record various metrics. The problem is that these spreadsheets are supposed to have the same headings and format to fit our set template but do not. It takes time...

Hi, i need to compare two columns for differences and highlight them; the columns may contain duplicate data. As example, for the below two columns, DWB931 on column A and DWD966 from column B should be highlighted. Note that there is one DWD966 in column A but two in column B. i need to do this...

Hi All I am a newbie here :warning: so please bare with me. I am trying to recon two sets of data both of which has two columns of info. I need excel/access to find the exact matches of the two sets of columns and to remove them leaving me with unique info for both the data sets as seen below...

How can I figure out what is in column A of sheet 2 that doesn't exist in column A of sheet 1.

Hello again! This community has been so helpful with my previous problems I've returned with another. This could be something simple; however, I can't seem to figure it out. I stole this code (off this site?) and I'm trying to re-work it to compare two columns based off of the position of...

Hello people, I need help with a code does following: loops through Column J and K if the values(text) are equal on the same row select the Value in Column B and (same row) divided by the value in Column AB (same row) and present the new value -1 in the Column T and if there is no value in...

I'm not an excel power user by any means, so i'm having trouble getting a column in one worksheet to compare against the same column in another worksheet. I have two different worksheets in the same workbook each sheet contains a different data with the exception of one column. The columns...

Have Excel 2003. Need some help from you kind more experienced folks. I have done some research but just have not found exactly what I am looking for. I have a list of email addresses in column a List of email addresses in column b. ** I would like a formula that will take all the values in...

Hi I'd like to compare two columns of data and highlight where a value doesn't occurr in both columns. The problem I have is that one of the columns uses * around the text to ensure it catches all variations of the value. I have the following formula which would work if the data was exactly...

Sometime back, I had posted a request on the above subject but there was a mistake in the same, as a result of which I did not receive any reply. I am posting the corrected thread again and request the member to help me out with my problem. I have two files, of which File1.xls is a master file...

I have two worksheets, of which Namelist.xls is a master file and the other one is named Namelistanddata.xls. Namelist.xls has 3 columns. Column B is titled "names" and there are 300 names. Namelistanddata.xls has columns A:P, with column D titled "names" having 5000 "names" and these 5000...

Hi, I need help with trying to perform the following opearation in excel: I need to update the prices of items in my inventory when my supplier gives me sends me a new pricelist. I need to build a macro I believe that will compare Item Codes in My Pricelist with Item Codes in New Pricelist and...

Hey all, I'm having a little difficulty with a vba macro I am creating in excel. Basically, item in column A may also appear in column B. I want the one with the greatest length in column C (In other words, Jennifer T Tamashiro is the same person as Tamashiro, Jennifer but since the first has...

Hi I have an Excel 2010 Pivot table . I want to compare the % difference between customer sales in 2009 and 2008. I have 3 columns at present Customer name ,Sales 2009 and Sales 2008. I would like a fourth column to show the % difference .Can someone assist me by outlining the process to do...

How do you write a macro, script or conditional formatting (or is there an add-in I can buy) that will use a partial text match from cells in one column (column J), to filter the list of phrases in another column (Column A). I found a formula that lets me filter column A by just one cell in...

I need to look for "ABC" in col B and if found, delete cell data for that row in Col A. Can you assist in how to do this. I have over 20K rows to review and would like a systemic way to accomplaish this. thanks in advance RT