Thread: Randomly Select cell from filtered list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt Ferguson Matt Ferguson is offline
external usenet poster
  
Posts: 1
Default 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
Reply With QuoteReply With Quote