Ok.. I am attaching the file (top 100 rows) after I have ran the macro..

What I did was

a) Opened the file
b) Clicked Alt+F11
c) on the worksheet I am working on I pasted the code from Tommy above
d) I saved it in VBA window, then closed VBA window to return to excel
e) I ran "test" - it gave me the results you can see , and came up with an "overflow" error, so it only went down to row 82, it didn't go any further
f) you can see the results of the code in cols S&T

I bet it's me doing something stupid!