title: Identify Duplicates or COUNTIF > 255 characters (long text)
body: <p>I have a strange problem, I have an excel document with two columns, col A contains the key, this is not unique, col b contains text of varying length, usually above 255 characters.</p>
  
  <p>I'd like to apply a filter to column A to select two keys, this is fine, I'd then like to identity any duplicates that exists within column B - applying only to fields that are visible, i.e. as a result of the filter on column A.</p>
  
  <p>This should be simple; however, the conditional formatting is failing to identify duplicates, I'm guessing because it does not like the length of the text.</p>
  
  <p>Even trying this the mandrolic way fails as the search box appears to only be able to accept a search string of a certain length.</p>