Hello folks,
Time for another homework problem. Assuming you have 2 ranges of values like below, how do you check if both of them have same set of values?
You may assume that these ranges are named range1 & range2.
Please post your answers in the comments section.
A bonus question…
How do you find the first equal set of source in the range target?
For example, for below scenario, source = 2nd column of target.
So the expected answer is 2 for this question.
Please assume the source & target ranges are named as source and target.
Go ahead and share your comments. I am very keen to see what kind of creative & elegant solutions we can come up to solve this problem.
Want more homework or Excel challenges?
Check out our Excel challenges page & homework tag for more problems. Be warned though, serious workouts for your brain ahead. Your mind will have a six pack at the end of it all.
