Hello,
How to find the duplicate values between two columns - A and B? Is it possible to mention Insource against A, if the name is duplicate and "outsource" if the name is not repeated.
Column
I have attached the excel sheet for your reference
REgards,
Asif
Last edited by asifamanulla; 10-19-2017 at 08:36 AM.
You have NOT attached the workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Apologies, attached
If I understand correctly then two rules would highlight the duplicates.
The rule to highlight names in column A that are duplicated in column B could be: =MATCH(A1,$B$1:$B$200,0)
The rule to highlight names in column B that are duplicated in column A could be: =MATCH(B1,A$1:A$200,0)
I don't understand the 'Insource' and 'Outsource' request, perhaps it would make things clearer if you could include an example or two of each on the spreadsheet attached to post #1.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Try this:
Select range A1:B161
Go to Conditional Formatting and Select Highlight Cells Rules from the menu and from the second menu choose Duplicate Values.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks