Comparing two sets of data and making sure they are the same

[faisalm2]

Hi

Basically I am doing a reconciliation (comparing two sets of data). The two sets of data consists of name, dates and completion dates of the course. How do I compare the two and make sure they are the same as each other. Please help!!!!!

 

[63falcondude]

I'm getting a better understanding now, If you can please show me how to do it on my spreadsheets that would be really really appreciated. I haven't got them on my computer and they are on my laptop which is being repaired should be back tommorow. If you are willing I can attach them tommorow and you can show me the right path!! Honestly help is really appreciated.

While you cannot upload workbooks directly to this site, you can upload them to a file sharing site such as dropbox and then share the link here.

That being said, a lot of us (me included) can not / will not click on links to download content for security reasons.

Your best bet is to create a small sample like I did in post #5 and share it here.

Here are is add-in that I use to create the HTML (MrExcel HTML Maker) that you see in post #'s 2 and 5: https://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[faisalm2]

Thank you will get back to you 100% tommorow! Never got help like this ever before. Amazing

 

[faisalm2]

[TABLE="width: 634"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Halima[/TD]
[TD]Abdella[/TD]
[TD][/TD]
[TD]01[/TD]
[TD]17-Mar-17[/TD]
[TD]31-Mar-17[/TD]
[/TR]
[TR]
[TD]Halima[/TD]
[TD]Abdella[/TD]
[TD][/TD]
[TD]02[/TD]
[TD]20-Mar-17[/TD]
[TD]28-Mar-17[/TD]
[/TR]
[TR]
[TD]Racheal[/TD]
[TD]Ackon[/TD]
[TD][/TD]
[TD]01[/TD]
[TD]03-Nov-16[/TD]
[TD]13-Jul-17[/TD]
[/TR]
[TR]
[TD]Susan[/TD]
[TD]Adams[/TD]
[TD][/TD]
[TD]01[/TD]
[TD]06-Feb-17[/TD]
[TD]13-Feb-17[/TD]
[/TR]
[TR]
[TD]Susan[/TD]
[TD]Adams[/TD]
[TD][/TD]
[TD]02[/TD]
[TD]22-Feb-17[/TD]
[TD]12-Jul-17[/TD]
[/TR]
[TR]
[TD]Alexandra[/TD]
[TD]Ainge[/TD]
[TD][/TD]
[TD]01[/TD]
[TD]12-Sep-16[/TD]
[TD]14-Mar-17[/TD]
[/TR]
[TR]
[TD]Carl[/TD]
[TD]Aldridge[/TD]
[TD][/TD]
[TD]01[/TD]
[TD]06-Feb-17[/TD]
[TD]13-Feb-17[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 256"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Halima[/TD]
[TD]Abdella [/TD]
[/TR]
[TR]
[TD]Halima[/TD]
[TD]Abdella[/TD]
[/TR]
[TR]
[TD]Rachael[/TD]
[TD]Ackon[/TD]
[/TR]
[TR]
[TD]Rachael [/TD]
[TD]Ackon[/TD]
[/TR]
[TR]
[TD]Rachael [/TD]
[TD]Ackon[/TD]
[/TR]
[TR]
[TD]Racheal[/TD]
[TD]Ackon[/TD]
[/TR]
[TR]
[TD]Susan[/TD]
[TD]Adams[/TD]
[/TR]
[TR]
[TD]Susan[/TD]
[TD]Adams
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 165"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]20-Mar-17[/TD]
[TD]28-Mar-17[/TD]
[/TR]
[TR]
[TD]03-Nov-16[/TD]
[TD]13-Jul-17[/TD]
[/TR]
[TR]
[TD]06-Feb-17[/TD]
[TD]13-Feb-17[/TD]
[/TR]
[TR]
[TD]22-Feb-17[/TD]
[TD]12-Jul-17[/TD]
[/TR]
[TR]
[TD]12-Sep-16[/TD]
[TD]14-Mar-17[/TD]
[/TR]
[TR]
[TD]06-Feb-17[/TD]
[TD]13-Feb-17[/TD]
[/TR]
[TR]
[TD]06-Feb-17[/TD]
[TD]13-Feb-17[/TD]
[/TR]
[TR]
[TD]06-Feb-17[/TD]
[TD]13-Feb-17[/TD]
[/TR]
</tbody>[/TABLE]


The data is above falcon, basically the first table is from one workbook, with peoples names and there course which i never put in, only there dates. So that is why they are replicating. Which I tried to point out yesterday showing the names not being unique and the second table is below. But i couldn't put the dates next to the names unfortunately.

 

[faisalm2]

Also I tried your method on post #5, It came back with too many arguments.

 

[Joe4]

Cross-posted here:
https://www.excelguru.ca/forums/sho...rom-one-workbook-to-another&p=32259#post32259
and here:
Comparing detail from two work books

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[63falcondude]

Responding to post #13: With your data like this (below), what would the end result look like (i.e. which cells should be highlighted)?

Excel 2010
	A	B	C	D	E
1	First Name	Last Name	Course	Start Date	End Date
2	Halima	Abdella	1	17-Mar-17	31-Mar-17
3	Halima	Abdella	2	20-Mar-17	28-Mar-17
4	Racheal	Ackon	1	3-Nov-16	13-Jul-17
5	Susan	Adams	1	6-Feb-17	13-Feb-17
6	Susan	Adams	2	22-Feb-17	12-Jul-17
7	Alexandra	Ainge	1	12-Sep-16	14-Mar-17
8	Carl	Aldridge	1	6-Feb-17	13-Feb-17
9
10
11	First Name	Last Name	Start Date	End Date
12	Halima	Abdella	20-Mar-17	28-Mar-17
13	Halima	Abdella	3-Nov-16	13-Jul-17
14	Rachael	Ackon	6-Feb-17	13-Feb-17
15	Rachael	Ackon	22-Feb-17	12-Jul-17
16	Rachael	Ackon	12-Sep-16	14-Mar-17
17	Racheal	Ackon	6-Feb-17	13-Feb-17
18	Susan	Adams	6-Feb-17	13-Feb-17
19	Susan	Adams	6-Feb-17	13-Feb-17
Sheet1