title: Excel Macro Arrays
body: <p>Currently I have a macro that runs through a list and deletes duplicate values (in one column), but it's proving to be very inefficient. For every entry that it checks for duplicates, it has to run through the whole column; my file currently has 50,000 entries and that is no small task. </p>
  
  <p>I think an easier way for the macro to work is for the macro to check if this value is in an array. If it is, then remove the row that the entry is in. If it isn't, add the value to the array.</p>
  
  <p>Can someone provide some help with the basic outline of the macro? Thanks</p>