Forum Discussion
Opposite Intersection
Hi Anonymous
I tried to use your code to create a new query with my file but it gave me an error.
Here is the screenshot of the error. Maybe it might help you understand where am I going wrong here.
I am not really familiar to the advanced editor in the query.
So if you could please modify your code according to my file, that way I should be able to get a better understanding of your code and how it works.
Here is the link to the file in my one drive.
https://1drv.ms/x/s!Ap0qSKP-4qpThBkZj5kXIu1RAoSJ
And my apologies for the late response.
Thank you,
Vishesh Jain
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