Excel sample file is attached.
I have two column B and D. Both have data from row 3 to 1817. So the selection is large. Also I have duplicate conditional formatting in those two column.
Like in this case, only one duplicate is there in B114 and D269.
I want to use "if" formula in cell, say G5, to display yes or no, if there is atleast one duplicate in them.
Thank you.
Not sure which way round - or how - you want this, but see if this will get you started...
G5=IF(COUNTIF($B$3:$B$1817,D5)>0,"Yes","No")
Copied down
I would suggest that, if you use this, you change teh No to just "" that way, the duplicates will stand out better...
=IF(COUNTIF($B$3:$B$1817,D5)>0,"Yes","")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks