View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JAgger1 JAgger1 is offline
external usenet poster
 
Posts: 42
Default RAND function without duplicates?

I have a set of 20 numbers in cell A1:T1

I'm using =INDEX($A1:$T1,RAND()*COUNTA($A1:$T1)) in cell W1 to Z1 to
randomly select 4 numbers from my set. How would I modify my formula
so as to not get any duplicate's? Thanks