Hi Everyone,
Got a little problem that you might be able to help. Either via formula or Macro would be very much appreciated.
Here's the issue.
I have 3 Columns A, B and C.
I wish to do a compare wherein, any values that are identical from columns A & B will be filtered/removed.
I have attached a dummy spreadsheet. You will also view from there the returned result I am trying to achieve.
Hope you could have a look.
Thank you in advance
Andrew
Last edited by Andrew.Trevayne; 10-21-2011 at 02:20 AM.
kumusta,
Please Login or Register to view this content.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Vlady
Salamat! ^^
But I tried to click and nothing seems to happen =(
Am I doing something wrong?
Andrew.Trevayne,
This code is longer but is also accurate and more versatile. If you need to change which columns to look for duplicates in, just change DupCol1 and DupCol2 as necessary:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Wow! This is great! Thanks to you both ^^
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks