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?
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Celebrate Holi with this colorful Excel file||Share your favorite Excel tip & you could win Beats Headphones [Podcast Anniversary Celebrations] »|