Dear all,
I have 2 Two worksheets which I need to compare and I would like to display the similarities in the 3rd sheet.
Sheet1 has the following data:-
No. Name 1 Federrer 3 Nadal 4 Djokovic
Sheet2 has the following data:-
No. Name 1 Federrer 2 Murray 3 Nadal
Sheet 3 should have:-
No. Name 1 Federrer 3 Nadal
Kindly keep in mind that rows of data in either sheets can vary from time to time.
Many thanks,
Vinod Krishna
Last edited by Vinod Krishna.C; 07-24-2013 at 09:36 AM.
As you are returning a single value, why can not you use Index and match formula?
Hello AB33,
Thank you for your inputs.
Wel, I actually have 4 columns with approx 3500+ rows of data.
I would like to know what exactly you meant by " returning a single value"?
It would be great if you can help me understand your solution with a smal example and VBA code for the same.
Thanks in advance.
If you want a VBA solution, please attach a sample excel book.
Sample data has been attached.
I'm mostly looking for logic.
Many Thanks,
Vinod Krishna
Will try to come up with formula as well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks