Hello, fellas!
Sorry in advance for a dumb question, but for me it is a real stumbling block. Ok, cut to the chase. I have to compare two ranges of an array and find a single coincidance.
For example (take a look at the attached image), I want to compare column X2, Y6 with column X4,Y6. The only common value between them is number 1.
- How do I find the coinsidance?
- How to store that common value (number 1 in this precise case) to a variable?
Thank you in advance.