In the attached file you will see that the date/time stamps in the 4 columns don't match up, so initially I need to identify which cells in the 3 columns on the right are closest to the one on the left. For example in column 1 we have 20/09/2012 01:23. In column 3 the closest value to that would be 20/09/2012 01:19, column 5 20/09/2012 01:23, and column 7 20/09/2012 01:18.
That is part 1 - identifying the closest value to the original set.
Part 2. Once this is done then I need to display the corresponding value to the right of the date/time. For example if the closest date/time in column 3 is 20/09/2012 01:19, the value I need to display would be 19.1
-----------------------------------------------------------------------------------------------
Essentially the whole point of this is I need to average the little numbers to the right of each time and date, but obviously need to identify the corresponding numbers in each column and match them up before I can average the 4 of them.
Any help would be AMAZING - I have been banging my head against a brick wall for days...Test.xls
Bookmarks