Hi folks, this should be an easy one i expect.
I have data in column A, between lines 5 and 13.
In column B, I have more data (same lines), some of which MAY already be in column A
Column C is where the formula will sit, and I'd like to have a returned value or 1 or 0.
1 being a match against column A, 0 indicating no match.
ps, i'm a rookie with excel, forums and most things online, so excuse my lack of jargon!
you can use countif
=countif($a$1:$a$100,b1)
if there would be multiple duplicate you can nest it in if function
=if(countif($a$1:$a$100,b1)>0,1,0)
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks