Comparing two sets of tests

Hey Guys
Im doing some research for my PhD, and I need to compare to sets of tests, to see if they where taken within 30 days of each other.

So i got TEST A with like 500 people that have taken the test a random number of times. And I got TEST B, which is the same. I now want to see which of the people have taken both tests (with a maximum of 30 days between the dates)
For each test i got their social security number and the date(s) they took the test.

Could this be solved with a function, or do I need to make a macro? And can any of you help me along the way? plz!

Best Regards
Tipsmark

it can be done with a formula but we'll need a sample of your workbook to see how your data is arranged
and build the formula accordingly.
Can you attach your workbook to your thread?
Regards

You may try Vlookup as
G2:

Please Login or Register  to view this content.

You may copy + past special + values to another column and sort to remove the blank cells.

See attached

Thanks

You better better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

already asked in #2.

Hey
I just got a small problem here, I only have the danish version of excel, so all my fomulars is also in danish. Hope you can bear with me.
Ive attached a small sample file (The one that Mahju made), and included the fomular made by quekbc.
As you can see, participant '6' gets a NO, even though he took both tests within 30 days of eachother, this is because the formular only checks for one instance of the test, and not all of them.

Hope that helped, I'm new with this so please bear with me

BTW: The date format I use is DAY/MONTH/YEAR

(really need to get english version installed so i don't have to translate formulars all the time :/)


UPDATED file with expected outcome --- See 3.0, can'd delete 2.0 :/

If you add your file with the danish formula's, excel translate that automatic in the regional settings (in my case Dutch), for another one (English).

Please also add manualy the expected result in your file.

6 6-5-2015 NO YES
6 6-8-2015 YES YES

Why is the result on the first 6 expected YES.

If one of the values (of 6) meets the criteria, it meets the criteria or not?