Forum Discussion
Opposite Intersection
HI mail2vjj,
Maybe you can take a look at below sample, I modify the formula to use sheet result as reference.(you need to go to query editor and relocate your excel file)
Regards,
Xiaoxin Sheng
Hi Anonymous
Your solution works!
I had to make a couple of tweaks to it, like change the name of file in the code and add the name of the columns.
The biggest change I had to make, though I didn't really understand why, was to move the 'Date' and 'Name' columns to the beginning of the table.
After that your solution worked but only for a table that already exists. I tried to use it with an Appended Table and it gave me an error.
However, after everything it is working now.
If you could please post your solution with the zip file again and mention the tweaks that I made, then it would help other people in the future.
Thank you so much for your help.
Vishesh Jain