Unique List from formula help to remove "0"

[Arcticwarrio]

Hello again,

i have a range named MATS (F9:F58)

and this formula in C9 and dragged down 20 rows

=IFERROR(INDEX(MATS, MATCH(MIN(IF(COUNTIF($C$8:C8, MATS)=0, 1, MAX((COUNTIF(MATS, "<"&MATS)+1)*2))*(COUNTIF(MATS, "<"&MATS)+1)), COUNTIF(MATS, "<"&MATS)+1, 0)), "")

this is a typical contents of MATS:

[TABLE="width: 97"]
<tbody>[TR]
[TD]5MM MS[/TD]
[/TR]
[TR]
[TD]5MM MS[/TD]
[/TR]
[TR]
[TD]5MM MS[/TD]
[/TR]
[TR]
[TD]5MM MS[/TD]
[/TR]
[TR]
[TD]5MM MS[/TD]
[/TR]
[TR]
[TD]8MM MS[/TD]
[/TR]
[TR]
[TD]8MM MS[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

and in column C outputs:

[TABLE="width: 138"]
<tbody>[TR]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]5MM MS
8MM MS[/TD]
[/TR]
</tbody>[/TABLE]

i need for the above formula to omit 0 (zero)

any ideas or better ways to filter the list?

Cheers
Arctic.

 

[Arcticwarrio]

p.s. the content of MATS is a vlookup, if i set blank cells to an apostophe it ignore them, but not if they are blank.