Hello
I almost found the solution from this thread (http://www.ozgrid.com/forum/showthread.php?t=176061&), but I couldn't edit it for my needs.
I have two tables, where table1 has several successful results per id, with different timestamps. Table2 has also several coordinate results with id and timestamp. I want to find those coordinates for id, where the result in table1 appears.
I have analyse that this excel macro I copied from that discussion, didn't work if there were several results in table1. And because there is million excel rows in table2, the running crashed several times...
I also attached the example table, to help the understanding.forum.ozgrid.com/index.php?attachment/68770/
ps. this is my first post, so i hope this didn't break the rules... and I also added this question to stackoverflow:
http://stackoverflow.com/quest…m-other-table-excel-macro