Filter n rows

[kuldeep]

I have an excel file in which for one state there are 500 records and total state are 80, i want to filter any 50 rows for all the state, how it can be filter?

[royUK]

Attach an example workbook & give more details of your request