Saturday, December 8, 2012

yogi_Create An Array Of Unique Random Numbers With Lower And Upper Values As Specified

                                          Google Spreadsheet   Post  #920
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Dec 8, 2012
user AlanVictor said:(!category-topic/docs/spreadsheets/L45BOYZrvRw)
Apply RANDBETWEEN function to all cells in a column of Google Spreadsheet

I'm trying to learn form creation using Google Docs and have managed to prepare a Performance Tracker form linked to the spreadsheet (

The last column (Task ID) should auto-feed the function =RANDBETWEEN(1000,9999) to each row being populated by the data pushed to the spreadsheet by the form.

Would really need help on:

1. The steps to be followed to make this possible.
2. Does RANDBETWEEN create duplicate numbers before exhausting the limit? If so, how can it the formula be configured not to duplicate values?

Thanks in advance!!!

PS; I have programming background in C++ only so would need some clarity about functionality of Google scripts which could be used in this case presented.

following is a solution to a bit more generalized problem