Thread: Randomly selecting a cell weighted on percentage
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Randomly selecting a cell weighted on percentage
Disregard the earlier which was wrong. Sorry ..

Formula in A5 should read as:
=INDEX($A$1:$D$1,MATCH(RAND(),$A$3:$D$3,1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote