title: Excel formula to create a unique list produces a 0 at the bottom that I cannot remove
body: <p>Here's my situation</p>
  
  <p>Goal: create a unique list in sheet2 based on a list with duplicates in sheet1.</p>
  
  <p>What I've tried: ={IFERROR(INDEX(Sheet1!$B$2:$B$100,MATCH(0,COUNTIF($B$2:B2,Sheet1!$B$2:$B$100),0)),"")}</p>
  
  <p>The issue: the formula produces the list I'm looking for, however it produces a 0 at the end of the list (e.g. B3 through B25 is correct but cell B26 has a 0). The problem is I can't figure out how to delete it. I've tried an if(0,"") statement and that doesn't work. Note, my list in Sheet1 only has about 25 total entries, however I want the formula to read to B100 to account for additional material. I did however try the formula ending exactly where my list ends and that does not produce a zero.</p>
  
  <p>If anyone has any ideas, please let me know.</p>
  
  <p>Thanks</p>