comparing

Hello All, I am comparing two sheets. Changes should be saved in the new sheets. If there are any new lines, add, removed, changes I got one information from you tube, however when I try it real time scenario it not working. Please advise if anyone from the forum would be able to help me...

Hi, I have a following serious query and dont know what to do? Please help. I need to display common text by comparing Column A and B and also require to have unique value "ABC123" ........ with the text in Column C. Is there any way to do this? Excel 2010AB1ABC123 John DavidDavid...

<tbody> Hi, All the expert people out there. I am stuck in a problem and have tried lots of option but no success.I have two sheets in one worksheet and I am comparing 2 columns to retrieve the value from one into another. screenshot attached The problem is that the sheet I am retrieving the...

Hi everyone, (Excel 2013) As you can see I have to compare the range of cell values (orders) from 2015-08-28 till 38. week with stock value. (Probably I should know more about conitional formatting) If the orders value greater then stock value turn the rest of the cell (time/orders) to red...

Hi I am trying to create a VBA code that allows me to compare rows data between last month and this. For example. Last month 1 A 2 B 3 C 4 D 41 E 5 F 6 G 7 H This month 1 2 2a 3 4 5 5b 6 7 8 Thus, I would manual check row by row, to ensure that the data in lastmonth is update to date. this...

Hello, I haven't found a similar question nor answer to this problem yet, so I'm posting it here hoping someone can help out. I want to compare the costs of different transportation methods. These costs differ by the country, zipcode and the amount you need to send (packages or pallets). Users...

Hi all, Please see soccer data below. Although it's fairly easy to do a 'more than' between two values. Can someone point me in the right direction to find scores were the winner has won by only by one goal? Can this only be done in VBA? Any pointers in the correct direction would be most...

Hello everyone, I need to compare a list of 300 emails, which is one file, to another list of 4k emails in another file. I would like the emails that are found on the 4k list to be automatically highlighted. I have tried VLOOUP with a series of different settings and I have tried Conditional...

Ok, I have 2 columns of dates that I am trying to make sure they all match, so what I did was use the Duplicate feature. Well, the problem with it, is it compares all the cells and not just side by side...but up and down so if the same date appears anywhere else in the document, it's not...

I'm trying to compare the values of columns B and G and if any of the cells are G < B, I would like to move the whole row into the second worksheet. And only if possible, it would be awesome if the macro could check column A for duplicates before the value comparison and sum up the column B if...

Hi, I'm trying to find the difference between two alphanumeric cells. For example: <tbody> C K P 1 1AB 2BC 1 2 2AB 4BC+ 2 3 2AB 5BC 3 </tbody> Conditions: - The columns that I am comparing are not next to each other, nor do they start at A1. - The letters in the cell do not need to...

So I have a dilemma and I have made it work before but for some reason I can't remember how I did it or where I saved the file that i did it in before. I would like to align two columns of data side by side. one column has less rows than the other so I need a macro that will move the one...

hello folks, I am caught up in solving a problem wherein there are two columns A and B and values there in A B 1 1 2 2 3 3 4 4 9 5 10 6 11 13 15 15 As you can see...

Hi everyone :biggrin:, Here's my problem i have an excel sheet with appoxiamtely 13,000 entries and i need to compare 2 columns versus two other columns within the same excel sheet by looking for the same entry. So i want to have something that will look at the name in Column H and then look...

<TABLE style="WIDTH: 712pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=948><COLGROUP><COL style="WIDTH: 16pt; mso-width-source: userset; mso-width-alt: 768" width=21><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 98pt; mso-width-source: userset...

I'm currently working on sorting a column of data from a PDF file into separate columns to later compare to another sheet. I'm having a few problems getting the data into a workable format, and also don't know how to compare to the other file. These are the specific issues, if someone can help...

This should be sooooo simple I am embarassed to ask. I have a set of dates in a colum and I want to put a 1 or a 2 in another column depending on if a that date is older/newer than X. Here are the actuals: Column A: Starting row is 2 10/30/2009 6/30/2008 2/15/2009 11/6/2009 6/20/2008 8/21/2008...