Randomly Select cell from filtered list
 

I need help with generating a random selection of 10 entires from a list. I want the random selection to be able to select cell from the list when it is filtered. As an example I have 100 subjects in 5 different states. I want to filter out one state reducing my list size (by 20). I want to randly select 10 subjects from the filtered list which now has 8o subjects listed.

EggHeadCafe - Software Developer Portal of Choice
GOT INTERFACE?
http://www.eggheadcafe.com/tutorials...interface.aspx

Randomly Select cell from filtered list
 

Excel 2007 PivotTable
Select 10 subjects at random.
http://www.mediafire.com/file/ijo5rm...11_25_09b.xlsx
http://c0444202.cdn.cloudfiles.racks...11_25_09b.xlsx