Filter spreadsheet test data

What’s the best way to filter test data stored in a spreadsheet please? For example, lets say I have a thousand rows of test data in a spreadsheet representing customer information, which is being used to drive my test suite using data binding. Is it possible to filter the spreadsheet so that my test suite only executes rows of test data where the state is “CO”?

This is a F.A.Q in this forum. In short, there is no built-in feature to “Filter spreadsheet test data”. But you can invent your way. Please search this forum for relevant topics. You will find some. For example,

Thanks for the help, I’ll check this FAQ out