Filter

[M]

Hi. I used to work with Excel 2007 and it was easy to filter. I could just go
through and check the ones I wanted to filter. But, with Excel 2003, I am
lost.

I am wanting to sort out just the States that we serve, they are all in one
column, I just dont know how to filter out just the 16 or so states that we
serve.

And I am reading all of the responses for other peoples, and I have no clue
what they are saying.

Could someone tell me how to filter out the results like I could in 2007?

 

[Sheeloo]

It is not possible to do it like Excel 2007...
Here is a workaround...

In an unused colum to the right of your data enter the column (say Z)
heading for the states column
Below the heading enter the states you want, one in each row...

Now select your data, choose Data->Filter->Advanced Filter
and in the criteria enter the range where you entered your states (Z1:Z17 if
you have 16 states)

You can specify anothr location or filter in place..