Match lists (date and time columns) in excel

[Mergh06]

Greetings,
I have a problem which I do not know how to handle..

Let me get to my point (an example is attached):

In sheet "Data" I have:

date in column A, time in column B, and important information in column C. (set 1)
date in column D, time in column E, and important information in column F. (set 2)
date in column G, time in column H, and important information in column I. (set 3)
... and so on along the columns (set xx)..

The above dates and time are not matched up in each row, and can be quite random. Each sets have the same number of rows, but the different
sets (which always have three columns) do not necessary have the same number of rows.
I need to take all the mutual common dates and time and match them up next to each other in each row at the second sheet "results"...

Sheet "results" should look like:
Date in column A, time in column B, and important information in column C D E... (and so on).

All the rows that do not have a mutual common date and time, should not appear in the results (included the attached information)...
Notice, that I highlight the date, time and results in the attached file.

I would really appreciate help with such kind of problem.

Hope to hear from someone - thanks in advance,
-mergh

[nilem]

Hi Mergh,
try it

Please Login or Register  to view this content.

[Mergh06]

Nilem!,
Looks like it works great!... thanks very much!
Very helpful

[Mergh06]

One little hole:

If set 1 and set 2 matches (without set 3), then the program matches these 2 sets and use Not a Number in the third set. I only need to match sets where All 3 set matches (and set x, if more sets). This mean that the result should not leave any cells with Not a Number.. I attached an example with the problem (i highlighted the mistake with red)

Thanks in advance!
-Mergh

[nilem]

let's put a patch

Please Login or Register  to view this content.

[Mergh06]

great, now it seems to be perfect thanks for help!
-MB