I need help choosing 2500 cells out of 30k at random but I need the picking to be evenly distributed.
The cells all have a classified category , for example there may be different names but they may share the same state.

So I would like to somehow pick 2500 at random but pick evenly among the states, so that I don't choose at random a majority from NY but not that many from NJ.

I'd prefer to do this using VBA.

I appreciate the assistance.