title: Generate ID based on text
body: <p>I have an Excel spreadsheet with a simple table on it. 
  The purpose of it is to log the price of a cryptocurrency I'm watching.</p>
  
  <p><img src="https://i.imgur.com/vyr0ubE.png" alt="TABLE"></p>
  
  <p>When I'm entering new data, I make a new line, put in the time and date, write which currency it is and whether it's down or up from my last listing. </p>
  
  <p>I'm wanting to put an ID column in to organise each cryptocurrency in how they're listed in the top 100 currencies.</p>
  
  <p>In this list you have <code>ARK</code>, <code>EOS</code>, <code>FunFair</code>, <code>IOTA</code>, and <code>NEM</code>. 
  The order is <code>IOTA</code>, <code>NEM</code>, <code>EOS</code>, <code>ARK</code>, <code>FunFair</code> in the list. So if I sort by Item/CC it should go by time/date, then ID, then name putting <code>IOTA</code> at the top with a simple <code>1</code> in the column.</p>
  
  <p>The question is, how do I write something like: </p>
  
  <pre><code>=if C:C = "IOTA" B:B = "1"
  </code></pre>