Hi
You can use a Pivot Table, using col A as row field, column B as column field and as Data field, then filter the column fields value to 1