View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Oligo Oligo is offline
external usenet poster
 
Posts: 27
Default how to return random non zero value to a particular cell?

A
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00000000
0.00872500
0.00000000

assuming the non zero valu(0.008725) might fall in any row. how can i get
that value into cell B1?