Why not use a pivot table and filter on 1? Are you familiar with how to do this?