title: How to detect uniques and count the number of cells with duplicate data
body: <p>I have a column of data that has the some of the same values in it. What I want to detect is if that row is unique. If it is, echo 'unique' (or something) but if it's not, count the number of duplicates in the column and echo that number. Example of what I want:</p>
  
  <pre><code>COL A     RESULT COLUMN
  Apple     Unique
  Banana    Unique
  Banana    3
  Banana    3
  Cherry    Unique
  Date      Unique
  Date      2
  </code></pre>
  
  <p>Example of what I have using this code (<code>=IF(A1=A2, "Duplicate", "Unique")</code>):</p>
  
  <pre><code>COL A     RESULT COLUMN
  Apple     Unique
  Banana    Unique
  Banana    DUPLICATE
  Banana    DUPLICATE
  Cherry    Unique
  Date      Unique
  Date      DUPLICATE
  </code></pre>
  
  <p>I guess what I really need is a query inserted(?) into where the 'Duplicate' text is in that formula that will count down the same cell values until it sees a different value, and echo that number.</p>
  
  <p>If it can be done within the same column excellent. If I need another column and have to perform two sets of queries I can compromise.</p>
  
  <p><strong>UPDATE BASED ON DATATOO ANSWER</strong></p>
  
  <p>I ran that query, modified column 'A' to 'E' and this is what returned.</p>
  
  <pre><code>City Country Merge  Duplicate City Country
  Aberdeen, UK    Unique
  Aberdeen, UK    2
  Bangor, UK          2
  Bath, UK            Unique
  Belfast, UK         Unique
  Birmingham, UK  Unique
  Birmingham, UK  Unique
  Birmingham, UK  Unique
  Birmingham, UK  Unique
  Birmingham, UK  Unique
  Birmingham, UK  Unique
  Birmingham, UK  Unique
  Birmingham, UK  Unique
  </code></pre>
  
  <p>As you can see this doesn't count right. Thoughts?</p>