5 responses

  1. Finnur
    December 8, 2009

    Great tips. That p.s. made me laugh out loud hehe.

    Reply

  2. Hui…
    December 8, 2009

    I also use
    – Random day in specific Yr and Month
    +Date(2009,12,int(Randbetween(0,31)+1))
    If you want a Random Year or Month, change the location of the Randbetween to suit

    – Random Upper Case Letters
    +char(randbetween(65,90))

    – Random Lower Case Letters
    +char(randbetween(97,122))

    – Random Choices from a small list (4 in this case)
    =+CHOOSE(INT(RAND()*4)+1,”Option A”,”Option B”,”Option C”,”Option D”)

    – Random Choices from a Large list on a Page in Column A2:A100
    =+OFFSET(A1,INT(RANDBETWEEN(0,100)),0)

    Reply

  3. Hui…
    December 8, 2009

    Lets try that whole post again
    —–
    I also use
    —–
    Random day in specific Yr and Month
    =+Date(2009,12,Randbetween(0,31)) ‘ Random Day in Dec 2009
    =+Date(2009,Randbetween(0,12),1) ‘ Random 1st of Month in 2009
    =+Date(Randbetween(2000,2009),1,1) ‘ 1st January Random Yr
    —–
    Random Upper Case Letters
    =+char(randbetween(65,90))
    —–
    Random Lower Case Letters
    =+char(randbetween(97,122))
    —–
    Random Choices from a small list (4 in this case)
    =+CHOOSE(INT(RAND()*4)+1,”Option A”,”Option B”,”Option C”,”Option D”)
    —–
    Random Choices from a Large list on a Page in Column A2:A100
    =+OFFSET(A1,INT(RANDBETWEEN(0,100)),0)

    Reply

  4. Chintan Parmar
    February 16, 2012

    is there any formula to select range of data. so that that formula can be use in vlookup formula. or sumif / countif

    Reply

  5. Hui…
    February 16, 2012

Leave a Reply

 

 

 

Back to top
mobile desktop