Thread: Random Text selection Q
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
  
Posts: 454
Default Random Text selection Q
I have 10 text statements in A1:A10. Is it possible to return in A15 1
radom selection from this range, only proviso is that if Z1=0, <blank
i.e. don't show anything in A15

Is this possible?
Reply With QuoteReply With Quote