VBA Tutorial - Compare 2 Data Sets

I have two sets of data that contain two companies sales targets. The data is as followed:
Data 1
Target Actual
Jan-06 12 13
Feb-06 12 14
Mar-06 31 30
Apr-06 10 11
May-06 15 14
Jun-06 15 13
Jul-06 15 16
Aug-06 54 55
Sep-06 9 10
Oct-06 12 11
Nov-06 13 11
Dec-06 8 7

Data2
Jan-06 14 13
Feb-06 12 11
Mar-06 35 33
Apr-06 10 12
May-06 15 14
Jun-06 15 13
Jul-06 15 12
Aug-06 54 57
Sep-06 9 12
Oct-06 12 13
Nov-06 13 8
Dec-06 8 7

I need to work out which company performed better. Each company has different targets so i need to no based on there targets who was better.

Hello, I'm somewhat new at this, well, it's been a long time since i've had to do this anyway,

I need help with something I need to do for my job. We have two sets of data, which have been sorted by a sequnce number (seqno) What we need done is to see if the second set, called 12D, has a match in the first set, 08D. If it does, we need to copy all the information in that data set from 8D, bascily columns A-I, next to the information from the 12D data set, so we can manual compare them. I think a macro would be best here, but not sure, can anyone help?

I have 2 columns of names.

A list of employees who have been absent in one worksheet and a list of all employees in another worksheet.

I need to return the names of the people that haven't been absent on to a separate worksheet.

Please help, is it a vlookup? I'm assuming I will also need an IF.

Thanking you in advance for your help.

I have two data sheets that I need to compare. Sheet one contains agent IDs and all their customers for each state. The second sheet contains the registrations the agent holds for each state (registrations can be at the city level, state level, or no registration at all)

The first step is to consolidate the first data sheet. For example, there may be 10 line items for one agent. Of the 10 line items, 4 customers reside in NY, 3 reside in NJ, and 3 reside in CT. This would be consolidated into 3 line items, which would be agent ID, agent name, the state, and number of clients in each state:

Agent ID.....Name......State......Clients
123456.......Joe............NY.............4
123456.......Joe............NJ.............3
123456.......Joe............CT.............3

The second, and last step, is to determine the registration level the agent has for each state, if any. So the final output may be as follows:

Agent ID.....Name......State......Clients.........Registration
123456.......Joe............NY.............4...................STATE
123456.......Joe............NJ.............3....................CITY
123456.......Joe............CT.............3....................CITY

Attached is sample data along with desired output. Thanks for any comments.

Hi all,

I have 2 worksheets of what should be identical data and I want to check that the dates on both correspond.

Basically I have 3 columns of data thousands of rows long with information in cell A and B with the date in column C (I have 2 sets of this data but the date may have been edited in one at some point didn't get updated in the other)

I know columns A and B are identical as they never change, all the data in cells A & B correspond exactly (As in cell A1500 is the same as B1500)
The date in column C is the only one that may have been altered.

Is there a formula that I can use on a separate worksheet?
Maybe put the data from worksheet 1 in columns A,B & C and the data from worksheet 2 in columns D,E & F and use a pull-down formula in column G?
And how would I identify a discrepancy if there was one?

Also, there are multiple instances of the same date so would cells in column A and C maybe have to used to compare with cells in D and F rather than just using the date columns (C and F) for comparison?

I hope that's not too confusing!!

I have 2003 and 2007

Any help is very much appreciated.

Thanks

Hi:

I have two sets of data, and I want to count how many matches there are.
For instance say on one I have

A
B
C
D


and on the other I have

B
F
G
C

Can I tell excel to count how many items are in both sets?
The result for this case should be two.

Thanks!

I have 32 percentages (A1...A32).

I need to write a formula that will compare each percentage against every
other percentage without typing it in over and over again. Please Help

I have a list of several hundred color names in a worksheet. Some of those colors are discontinued, so I received a list of discontinued colors to update the master list.

Is there a way to compare the discontinued list to the master list and when ever a discontinued color matches on the master list, the master list color name cell is highlighted?

Any thoughts would be greatly appreciated.

Thank you in advance for your time

Hello,
I am looking for a single formula solution that searches the concatenated values of columns A & B for entries that do not match the concatenated values of: cell D1 and Range C4:C11, or E1 and Range C4:C11, and put the results in a list in column C from range C14:C30 as shown in the screen shot.
Thanks,
Ken

Sheet1 A B C D E 1 Work Order Sqwk W/O G1348 G1348I 2 G1348 105 STATUS AS OF: 06/03/11 3 G1348 105 SQK-100 PERFORM THE F/P EFFORT AS FOLLOWS FOR LH OUTBOARD AILERON: 4 G1348 110 105 CHECK ID & VERIFY PART NUMBER 5 G1348 115 110 DISASSEMBLE FOR STRIP 6 G1348 115 115 STRIP EXTERIOR 7 G1348 121 120 INSPECT STEEL FASTENERS FOR RUST & CORROSION 8 G1348 125 125 TOUCH-UP STEEL FASTENERS 9 G1348 125 130 REMOVE UPPER SURFACE PANELS 10 G1348 130 135 REVIEW AFTO FORM 103 11 G1348 135 140 INSPECT THE AILERON 12 G1348 135 SQK-100 Total 13 G1348 140 W/O & Sqwk MIS-CHARGED TIME 14 G1348I 105 G1348121 15 G1348I 110 G1348I1359 16 G1348I 110 17 G1348I 115 18 G1348I 115 19 G1348I 115 20 G1348I 120 21 G1348I 125 22 G1348I 130 23 G1348I 130 24 G1348I 139 25 G1348I 140 26 G1348I 140 Excel 2007

Hi,

I have a group of emails and I want to compare the two so that it creates a list of emails that are in set b but not in set a

So for example I have SET A AND SET B as follows

SET A

name1@email.com
name2@email.com
name3@email.com
name4@email.com
name5@email.com

SET B

name1@email.com
name2@email.com
name6@email.com
name7@email.com
name8@email.com

Therefore it will create a new list of emails that are in B but not in A

New List

name6@email.com
name7@email.com
name8@email.com

What will the best way of doing this? The new list can be a column on the same sheet or appear in a new sheet

Thanks

Tahir