Hi all,
Got a bit of a tough one here, which has confused me for days.
I have a table of data which is shown in my attached workbook as Sheet1 (Most of the data has been deleted for various reasons).
From this data the worksheet "Near Values" is produced, which looks at pairs of eastings and northings (from Columns Q and R in Sheet1) that are within 1km of each other.
I am looking at being able to run through Sheet1 and locate any instances that any of these pairings feature within 10 minutes of one another AND where their corresponding number in column AD is different - if the criteria is met then highlight the corresponding cells in column AB.
Any help much appreciated!
Kind Regards,
Chris
Bookmarks