title: What is the best way to filter a large list in Excel?
body: <p>I have a table in Excel that I want to filter.  It will have a maximum of 1 million rows and 80 columns.  All the calculations etc are done programatically in arrays to cut dwn processing time.  However, I want to also filter the results to display only certain results based on one column value, followed by a top 5% based on another filter value.</p>
  
  <p>When I first did the sheet, it was limited to 65000 results so there were no problems with the size of the data set.  I just invoked the worksheet filter functions from code and did it that way.  Can I do it that way with a larger data set or is there a way to filter an array the way you d a dataset on a sheet?</p>
  
  <p>Thanks</p>