What I described should give you the top 10 vendors per state in the
Did you click on the Vendor field before you opened the Sort and Top 10
Is the State field to the left of the Vendor field in the row area?
There's an example in the following article that may help you:
Excel FAQ, Tips & Book List