LinkBack URL
About LinkBacks
if you could upload a sample of non-company confidential data that would help....looks like there are a few missing....or just plug away, cuz that can be fun also....
if you could upload a sample of non-company confidential data that would help....looks like there are a few missing....or just plug away, cuz that can be fun also....
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Attaching a file (it's just publication data from databases like PubMed) - you'll see the columns I'm referring to are Sheet 1 Column B and Sheet 2 Column D. Easiest route might be to remove the periods, but if there's a way around it, great! It's not just these 80 or so publications as you can imagine, or I wouldn't be looking for a way to streamline this!
Thanks - always grateful for help!!
give this a try
=IF(COUNTIFS(Sheet1!B:B,LEFT(D2,LEN(D2)-1))>0,"Dups",IF(COUNTIFS(Sheet1!B:B,D2)>0,"Dups","No Dups"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks