title: Excel crashes on large array lookups
body: <p>I have some firewall logs I am looking through and I want to arrange them so that excel shows me the first and last timestamp (two separate columns) for each IP.
  I have a table with five columns:</p>
  
  <ul>
  <li>ColumnA: Unique IP addresses (count:1,275)</li>
  <li>ColumnB:Where I would like the first accessed times to be</li>
  <li>ColumnC:Where I would like the last accessed times to be</li>
  <li>ColumnD: Non uniqued IP addresses (count:300,001)</li>
  <li>ColumnE: Non uniqued timestamps aligned with column 4 (count:300,001)</li>
  </ul>
  
  <p>My formula seems to work fine on smaller data sets but excel crashes when I try to do this, understandably so since it is a 400k line table. Is there a way to make this less CPU intensive so that Excel completes this? Is there a better way to be doing this? Here is the current formula I am using:</p>
  
  <p><code>=MIN(IF(A1=D1:D400001,E1:E400001))</code></p>
  
  <p>ctrl+shift+enter</p>
  
  <p>Thank you!</p>