View Single Post
Old 05-05-2010, 07:28 PM  
96ukssob
So Fucking Banananananas
 
96ukssob's Avatar
 
Industry Role:
Join Date: Mar 2003
Location: If I was in your ass you'd know it
Posts: 12,991
d'oh, i figured it out... had to swap out a where it spit out the true vs. false value at

incase anyone wanted to know...
Code:
=IF(ISERROR(MATCH(A1,$C$1:$C$362,0)),A1," ")
*where column A = long list and column C = shortened list... hence finding terms in column A that are not in C
__________________
Email: Clicky on Me
96ukssob is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote