comparing columns

Im stuck at getting a macro to filter through some data. I have this data set; This continues for 1000s of rows, i need a macro to: Go through date/time col check for any overlaps where there are overlaps compare to ocular hazard col if both dates have ocular hazard 1 then only paste one of...

Good day please could you assist me, not sure if it is possible. I have two columns that return the top three results from a list, i would like to know if there is any way that i could compare the two lists and if the is a duplicate value/result in list b then this would be removed and the...

If I had three columns in one worksheet and three columns in another worksheet to compare. How can I check the 2nd worksheet to find matching records to the 1st worksheet, then pull out the fourth column value of the 2nd worksheet when there's a match? Ideally with codeor array rather than...

<colgroup><col><col></colgroup><tbody> Available grants Published Measuring productivity Services Data Set Census data Data Security Activity data Monthly analysis on last census Work Assessment Organisation Reference Data Smoking habits of adults Adult smoking Risk management...

Hi, I have a macro that is able to find differences between two columns that are side by side and then spits out the differences onto another sheet. The macro works well when there are differences, but if the two columns are the same, then I get a 400 error. What do I need to do so that my code...

I have two databases that each have invoice numbers and invoice dates. I need code that will first sort each list of data in ascending order. Then I need the code to compare the lists from each database. The output of the code should show where each invoice data is matching or missing. If...

I would like to compare two columns with numbers. If there is a match I will retrieve a number from a third column and put into a forth. Se below: PN1 Price PN2 Match 18-510-580 23 112 200005282 3794456 5 099...

I have the following columns of data: Sheet 1: Name Date Stock A 1/3/2013 Stock B 1/3/2012 Stock B.3 null Stock C 4/5/2013 Stock D 6/2/2013 Stock D.1 null Stock E 7/21/2013 Stock F 9/28/2013 ... Sheet 2 Stock A 1/3/2013 Stock A.3 4/3/2011 Stock B 1/3/2012...

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

in Excel 2010: I currently get Excel reports given to me from my companies CRM tool. It shows me activity history in every account. There are many duplicate values in the Account name column and I need to delete the duplicates leaving only the value for the time the account reached the...

Take a look at whiat I am trying to do, any input would be appreciated! (keep scrolling down, i dont know how i got all that extra space! LOL):biggrin: <TABLE border=1> <TBODY><TR> <TH>CONTRIBUTORS</TH> <TH>LAST NAMES</TH> </TR> <TR> <TD>JOHN PAUL GLADSTONE</TD>...