Randeom Number

[nidhipatel]

worksheet2 range C1:C150 show number i need range "D1" show random number from range C1:C150 but condition is all number of range C1:C150 i appear at once no number show again when open file when file is close and open again than random number show at once do not number is show twice from rang C1:C150

 

[Yongle]

Not sure if I understand what you want

Try this formula in D1
=INDIRECT(ADDRESS(RANDBETWEEN(1,150),3))

D1 returns a random value from range C1:C150

To return a different value use function key {F9}

 

[Legacy 143009]

worksheet2 range C1:C150 show number i need range "D1" show random number from range C1:C150 but condition is all number of range C1:C150 i appear at once no number show again when open file when file is close and open again than random number show at once do not number is show twice from rang C1:C150

D1 =INDIRECT("C"&RANDBETWEEN(1,150))

Have a nice day