Trouble with duplicate in table

I want remove the row Yes Yes No from Publisher 1108thaomy. This column was created because she did have an order before 08/11 and this transaction then is considered as ‘no order’ from 8-14/11. However I couldn’t remove it because the publisher below had the same status but she wasn’t duplicated. Thanks a lot

you can add new count field group on account no and add new filter where count is equal one.
This will show the single row always for any records have count 3 or 4

Naveed Ali