Check if 2 ranges have same values (set equality problem)
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?
Leave a Reply
|Celebrate Holi with this colorful Excel file||Share your favorite Excel tip & you could win Beats Headphones [Podcast Anniversary Celebrations]|