Random selection of multiple rows with two defined categories

Hi,

I have 30000 entries submitted by people. All these entries are registered by eldest member of family in his name and they are from 17 different states with 7 level of financial status type. I need to select specified no. (different nos. in each state with each type) of entries from each state with each type. How can i achieve this in excel.

rgds
geochd

Hi,
Thanks for reply.... I know filter function which is nothing to do with random selection. Request you to read thru my problems once again. Need to select certain no. of rows depending on conditions on value of two other columns. Pls help
rgds
geochd

Specified no. of rows means, I need to select X no. of rows from State1 with financial income bracket of 20K-30K out of total 30000 entries.

E.g.
Total entries 30,000, with each entry having detail of Survey Agency (total 3 agencies), State (total 17 states) and financial income bracket (total 7 brackets) defined.

In Agency 1 survey for state 1 has total 1077 entries with different no. of entries falling in 7 different financial brackets. I need to select randomly 16+2+1+43+7+14+7=90 entries out these 7 financial brackets.

Hope this explains

Pls help, anybody