Group wise Results Required

[jewnaa]

Dear Excel Experts

Hi

I need your help to sot out excel prob, I want to filter group wise IDs that's value(%) is not=0,

I have attached file.

Thanks

Jewnaa

[RobertMika]

help(1).xlsx

=iferror(index($b$2:$b$29,small(if($c$2:$c$29=f$4,if($d$2:$d$29<>0,row($d$2:$d$29)-row($c$2)+1)),rows($a$2:a2))),"")