Macro to check double entries within 24 hours

[cptolsen]

Hi guys!

Is there any way to double check if one entry also is listed in another section of my report.
This report is normally between 3000-5000 lines, so its a lot of data!

I need to have the result in the column "O" - behind each listing. If the same ship name is listed in the section called "Sømna kommune - Aktivitet I kommunens sjøareal" (starting at line 24 in this report), then it will give a result "1".

So for example on this report, if the entry B6 "Martin H" also is listed in the section "Sømna kommune - Aktivitet kommunens sjøareal", as it is in line 584, then it will give the result "1" in column "O6". But also one more criteria for setting the result to "1", is that the listing in "Sømna kommune - Aktivitet kommunens sjøareal" is within 24 hours from the arrival time (G6).

All listings in the section "Sømna kommune - Aktivitet i kommunens sjøareal" should not have the result in column O, since this section is only the reference data.


My english is not the best, so I just hope someone will understand this.. :D


Attached example.

report.png

[JeteMc]

Column G is filled with text as opposed to actual date and time values.
Column P converts the text in column G to date and time using: =SUM(DATE(RIGHT(LEFT(G5,10),4),RIGHT(LEFT(G5,5),2),LEFT(G5,2)),TIME(RIGHT(LEFT(G5,13),2),RIGHT(G5,2),0))
Column O is then populated using:

Please Login or Register  to view this content.

Let us know if you have any questions.

[cptolsen]

Column G is filled with text as opposed to actual date and time values.
Column P converts the text in column G to date and time using: =SUM(DATE(RIGHT(LEFT(G5,10),4),RIGHT(LEFT(G5,5),2),LEFT(G5,2)),TIME(RIGHT(LEFT(G5,13),2),RIGHT(G5,2),0))
Column O is then populated using:

Please Login or Register  to view this content.

Let us know if you have any questions.

Thank you so much!!!!

[JeteMc]

You're Welcome. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.