View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
2226 2226 is offline
external usenet poster
 
Posts: 7
Default Search an alphanumeric in a column and return true/false

I am having some revision numbers say c1, c2,c3,c4.... I want to know how to
make a search in column that contains C1 to C100 randomly (may be some
missing) and return true if that is present and false if it is not.