title: Excel Grouping and Logic
body: <p>I have some data in Excel. This is already sorted into the correct order. I require to set the value in a new column to true if it is either a solo record (ie only one distinct ID#) or if there are several entries for that same ID# then set the last one listed to True and the other ones above for that ID# to False. For example:</p>
  
  <pre><code>ID#   New Column    
  001   True    
  002   True    
  003   False    
  003   True    
  004   False       
  004   False    
  004   True    
  005   True
  </code></pre>
  
  <p>I need to be able to apply a cell formula to the Excel sheet to auto generate this new column or to run a macro to populate the column. Any help appreciated as this is beyond my skills with Excel!</p>