comparison

Hi, I have this script to compare: 'Option Explicit 'Sub FindDuplicate() 'Dim LastRow As Long 'Dim MyRg1 As Range, MyRg2 As Range 'Dim A As Range 'Dim F ' Application.ScreenUpdating = False 'LastRow = Range("a" & Rows.Count).End(xlUp).Row 'Range("B1:B" &...

Hi, Can someone help me to write a script that compares the value in columns A with columns B. If the value match in both columns then write the new data in new worksheet. I also winder where I can find an VBA Index there all functions are included like If, Else, For, Len etc. Where it is...

So I have a table... <tbody> A B C D E F G 54 8:45 Jane Paul 8:45 37 37 1:12 Dave Chris 5:35 78 78 5:35 Chris Jane 6:40 90 90 6:40 Jane Liz 2:05 14 37 8:45 Paul Sarah 7:30 54 82 3:14 Matt Jane 8:45 54 14 2:05 Liz Dave 1:12 37...

I have a master table of values that I am using to compare experimental data against. The experimental data has some blank values which must stay in the data set but must not be compared against the master table. There are 286 rows of 13 cells (which only contain 10 cells and 3 blank cells as...

Hi guys, I need to return the index based on values from 2 columns with largest amounts, below the example: From the below table, the index I need returned will be "Purchasing Data Inquiry" because even though this one does not have the biggest % has more number of hits (51) based in column...

I have a seemingly simple comparison that will only work part of the time. I have searched this and other forums and I just cant seem to find the issue. I'm using the following VBA code to compare and copy the value of the cell into the cell next to it if it matches. It is in a loop but the code...

Right firstly, apologies if this has been asked before but I have no idea how to shape the search to see if it has or hasn't been posted on before. I have a spreadsheet with quarter on quarter results for a set of penetration tests. I am trying to create a formula which will compare the...

Hi all, I was hoping you could help me with a problem. I have a spreadsheet that is made up of 3 tabs, Original, Match and Difference. It's purpose is to return the difference between 2 pasted reports (One is pasted in the Original Tab and the other in the Match Tab and the differences are...

Hello guys I am trying to right a macro that will compare different ranges with each other. Each range is enclosed by borders, so I would like the macro to compare what is within the borders to the next range. Essentially I am comparing the same functions from three different projects to see...

If I sent a document to someone in excel, and then they sent back their own saved verision of the document, is there a way to compare the two to show the changes made?

Hi all, I've been searching for an answer to this question on the internet and there are lots of similar things but nothing does exactly what I want it to do and I'm a bit of a VBA noobie. I am trying to compare two sheets within the same workbook (Sheet1 = Before and Sheet2 = After) row by...

I have two columns with names of people, <TABLE style="WIDTH: 241pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=322><COLGROUP><COL style="WIDTH: 89pt; mso-width-source: userset; mso-width-alt: 4352" width=119><COL style="WIDTH: 63pt; mso-width-source: userset...

Hello excel enthusiasts, I'm sure there is a way to do it, but I can't figure out the simplest way short of a really long really nested if function. I have a list (900 lines long) and then I have another list which corresponds to scores. Here is an example: 100 - A 90 - B 80 - C 70 - D 60...

Hello, I am trying to sort through two sets of sku's for different marketplaces however I have come into a problem and doing 2,000 by hand doesnt seem efficient. I need help on writing a formula to figure out if any SKU in Column A is also in Column D, and vice versa. If it is in Column D is...

I need help figuring out why I can't force dates to compare in the way that I want. I have worksheet and want to compare a date from a datePicker control to a date in a column to find a match. The column in the worksheet is given the Custom format "yyyy-mm-dd". I did not select the option that...

Hello, I was wondering how to correctly get an if statement to reference multiple entries. For example. I have a column 1 2 3 4 5 6 7 I want to add another column that says something like if(B1=2,3,4, "Group C", "") so if the value in cell B1 = 2, 3, or 4, then label "group C"...

I am trying to come up with a spreadsheet that has 1 page of sales from 6/18/07-8/16/07 (43 days), with 3 rows beneath each column: Row 45=Total (=Sum(b2:b44)), Row 46=Average (=Average(b2:b44)), and Row 47=Average + 10% (=Sum(b46+(b46*.1))). The next page has a daily input from 6/16/08-8/15/08...