I need to check each number in a column to see if the number also appears anywhere in another column. I have tried various IF commands, but can only get a TRUE if the number is on the same row.
I need a TRUE value if the number in the first column is found anywhere in the second column.
Any help would be appreciated.
Take a look at this link, it may help you
http://www.cpearson.com/excel/duplicat.htm
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thanks
Thanks for the help. It helped get me what I needed. Much appreciated.
Originally Posted by oldchippy
Anytime - thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks