table to show Non Zero

[vjharry]

i have attached a file where there is a sample data in Green naming "new"... in other table I want to show only those data where points are coming non Zero.
Sample file is attached herewith

[oeldere]

maybe with an pivot table.

[Ghozi Alkatiri]

array formula (C S E )

at F11
{=IFERROR(INDEX(A$3:A$8,SMALL(IF(new[points]<>0,MATCH(new[Name],new[Name],0)),ROW(1:1))),"")}
drag right and down.

[Ghozi Alkatiri]

sorry at A12