Locating pairs in set of data within time range

Thanks WBD!

Originally Posted by WideBoyDixon

You didn't attach anything ...

Oh yes Chris did - eventually.

Fantastic, thanks WBD! Works perfectly

How about incorporating this into it. Where the parings are now within a specific distance and a specific time, I'd like to look at whether they "Look at" one another.

When looking at the pairs, the 1st easting and northing is A and the 2nd (of the pair) is B. The pairs need to be looked at in conjunction with the data on the test workbook and specifically column O - which would contain a value of between 0 and 350 with the following parameters:

If A is NW of B then any value in Column O works as follows:
Between 90 – 180 for A would “Look at” B

If A is NE of B then any value in Column O works as follows:
Between 180-270 for A would “Look at” B

AND

If B is SE of A then any value in Column O works as follows:
Between 270-0 would “Look at” A

If B is SW of A then any value in Column O works as follows:
Between 0-90 would “Look at” B

Then highlighting where A and B would look at one another, or where A would look at B or vise versa. Not sure how to go about it as the first instance would be working out the position of the E&N's...

I think i've cracked it tbf WBD, using your help! Thank you.

Hi WBD,

Thanks for your code, it works perfectly - however I have changed my dataset slightly. As with the test workbook which I attached, the Eastings and Northings are now in columns C and D as opposed to B and C, as there is an extra column of data in Column B. How would I go about changing this, so the code can search the pairs from "Near Values" to see if they feature within 10 mins of one another in Sheet1?

Hi WBD,

Thank you very much, that worked perfectly (again).

Hi WBD,

I have changed my data again, so now when looking between Near Values and Sheet1 I am looking to use the values from Column U and V from the Near values sheet.

Similar to before, I am then looking in Sheet1 in Column M OR Q to see if these values feature within 10 minutes of one another, where there is a change in Column AD.

Is there anyway to amend the code to work with this?

Thank you very much for all your help so far, it is very much appreciated.

Hi WBD,

Massive thanks for your code, it works perfectly. Is there a way that when the cells are highlighted that a corresponding number is put in column D?

For example, on the attached workbook the criteria is met for you code in rows 2 and 5, so the cell in column AB is coloured and the criteria is met in rows 78-80, so the cell in column AB is coloured again.

As there are the only 2 where the criteria has been met I have manually added in numbers in the corresponding cell in column D, so D2 and D5 show the number 1 and D78-D80 show the number 2.

Is there a way this can be automated with the original code?

Many thanks,

Chris

Hi WBD,

Do you think you could assist with the above at all? Your code works brilliantly but I was looking to tweak it slightly.