I am using this formula in Excel 2016 so it doesn’t have the sort function.

=IFERROR(INDEX($F$41:$F$500, MATCH(SMALL(IF(COUNTIF($J$1:J1,$F$41:$F$500)=0,COUNTIF($F$41:$F$500,"<"&$F$41:$F$500),""),ROW(1:1)),COUNTIF($F$41:$F$500,"<"&$F$41:$F$500),0)),"")

Wanting this to begin in Cell J2 instead of J22. I believe it is because the formula I have needs to exclude blank cells and is not. Also, for some odd reason the formula is leaving some of the data out. I have in column B2:B35 what J2:J35 should look like. Highlighted are what should also be showing in J2:J35 formula.

Here is a link to it. https://1drv.ms/x/s!AgYDS7saPf0DhsYpr01N9vmZhFUtCQ?e=n7wz6Z

As you can see in these images, the referenced cells are not sorted and have blanks. I am needing the formula to sort and remove blanks. Thanks!