sanmaya, welcome to ExcelFox

Why don't you simply use AutoFilter for this, and just select all Yes and No