compare 2 columns

<tbody> J K 1 pct 1 pct 2 2 90 100 3 85 100 4 69 100 5 41 50 6 39 50 7 19 50 </tbody> I'm having trouble using conditional formatting to highlight one column based on the value of another column in a table, values are formatted as percentage(no decimal) . The table above contains...

Hi, I'm looking for a desperate answer regarding my problem, so if you have any suggestion please help: I have 3 columns who look like this: A B C <tbody> PT 199 Bragareasa PT 199 Bragareasa PT 199 Bragareasa 6 IND PT 130 Grindu 11IND PT Parc 5 Grindu 7/483 IND PT 5 Grindu 378...

I have two lists, one has 250 items, the other 4500, both contain a String I need to compare any word within a cell in the short list, against any word within a cell in the long list. The returned value needs to display both the short list item, as well as the long list item for manual...

Hi I have two columns of values and I want to compare them and return differing values. So I named the ranges "A" and "B" so if your in B but not in A I want that value in C. I started with a vlookup but that doesn't seem appropriate to the way I was using it. =VLOOKUP(B, A, A, FALSE) Is...

Dear Excel experts, I want to compare 2 columns based on their positive and negative values.. For example, A B C ID1 91 -7 ID2 -7 74 ID3 -4 -5 ID4 90 4 ID5 -55 34 ID6 33 3 I want to know 1) which id's have both negative values in...

So here I have two columns Column 1 with repetitive values of some 10000 records Column 2 with unique values of 100 records I want to compare Column 1 and Column 2, identify the values in Column 1 that match with Column 2 and highlight them. Conditional formatting for duplicate values doesnt...

Hi all, first post so please be nice! I am trying to figure this out but am having no luck with it whatsoever. What I am attempting(and failing!) to do is to compare 2 columns in two sheets and if a duplicate is found, copy the whole row to a third sheet. The data is set up with a list of...

Hi there, I have two sets of data that I need to show if there has been an increase or decrease in over a 2 year period so at present have something that looks like this: <TBODY> Year 1 Year 2 Postcode Number Postcode Number SY23 7 2875 SY66 2 2890 ST65 8 2700 SY23 7 2611 SY66 2...

Hello great minds, Im using windows vista with excel 2007. I have a list of phone numbers in column C and the last four digits to those phone number in column B not in order. Im looking for a function that would give me the address of my partial number in column B that is in column C? I have...

Hi. I'm having a problem that I need help with. Here it is. I have two columns of data. Each contains a 1 to 3 digit code. I need to compare column A to column B and if a code in A = a code in B, I need the entire row that intersects the cell in column A to be removed. Let me give the...

Hi all I've two excel sheets in one work book, Sheet 1 contains A - S No B - Mandal Name C - DISE Code (Numbers are stored in this column) D - Name of the School E - Account No (This column is empty, we need to fill this column by the formula) Sheet 2 contains A - S No B - Mandal Name C -...

Need help! I have two tables with 5 columns each. The first two columns in both tables contain ID#s and Names. The third column contain job titles in both tables. Table 2 has many more records that table1 - in other words table 1 is a subset of table 2. I want to compare these titles in the two...

Two columns of data - The A Column is the image name and the B Column is the product ID. The column B is not a sorted list. The images are named identical to the product ID they are associated with. I need to pair the image name with the Product Id, but I cannot sort the Column B, because...

hello! I have 2 worksbooks and i need to compare one column from workbook1 with another column from workbook2 and then I need to put the non-matched data into workbook3. Is it difficult to do in a macro? i dont have an idea to do that :( thanks for your help...

I have this spreadsheet... <tbody> A B C D E 8:45 26 85 9:49 14 30 10:34 85 14 11:12 30 26 3:05 90 30 2:33 14 90 12:45 26 26 1:00 90 14 2:45 30 90 </tbody> I need to put a formula in E that says...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

I have an worksheet with expenses for different items with name, date, receipt no., total etc. I need to create a top 10 list of expenses but when I sort I get only the Top 10 INDIVIDUAL receipts while I need all receipts under the same name to be added together and then listed. For eg. Name...

I am working with excel 2010. Here is an example of what I am trying to do A column Crisp prawn dumplings with green tea salt Roast fennel, mint and ruby grapefruit salad B column Bacon salad mint dumplings tea beef RESULT C column dumplings tea mint salad I am trying to...

I want to compare two columns in excel that have text in each cell. If in column 2 there is the same text with the column 1 then next to column 1 I need to be post next to the cell that there is the same text the word YES and if not then next to column 1 to be post NO. Column 1 cells is from...

We send out a newsletter and I'd like to find out how the recipients of the newsletter overlap with our customer lists - to find out how many who receive the newsletter have never become customers. In Column A, I have a list of all newsletter subscribers and in Column B I have a list of all of...