Pick random cells
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Pick random cells
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular
    Join Date
    Oct 2009
    Location
    Midlands, UK
    Posts
    7,509
    Post Thanks / Like
    Mentioned
    17 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Pick random cells

    Yes the counta is to return the last data. Are there any columns that are complete? If so use them. If not you could use an array formula like this one:

    =RANDBETWEEN(1,MAX(ROW(C1:C200000)*(C1:C200000<>"")))

  2. #12
    Board Regular
    Join Date
    Dec 2007
    Posts
    312
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pick random cells

    Hi,

    Quote Originally Posted by coldsteel404 View Post
    ... I'm Dutch.
    ASELECTTUSSEN(1,AANTALC($C$1:$C$160000))
    If European should you not use ";" between parameters rather than ","?

    e.g.
    Code:
    ASELECTTUSSEN(1;AANTALC($C$1:$C$160000))
    Eric.
    Last edited by Eric Golf; Dec 2nd, 2014 at 06:41 AM. Reason: minor typo

  3. #13
    New Member
    Join Date
    Nov 2014
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pick random cells

    ASELECTTUSSEN(1;AANTALC($C$1:$C$160000))Well, this time I didn't get an error, but I got #name in every cell so not quite there yet

    Also tried the formula with just 16 numbers ASELECTTUSSEN(1;AANTALC($C$1:$C$16)) since I was certrain the frist 16 are complete and it still didn't work

  4. #14
    Board Regular
    Join Date
    Oct 2009
    Location
    Midlands, UK
    Posts
    7,509
    Post Thanks / Like
    Mentioned
    17 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Pick random cells

    Does this help?

    Als deze functie niet beschikbaar is en de fout #NAAM? als resultaat wordt gegeven, moet u de invoegtoepassing Analysis ToolPak installeren en laden.

  5. #15
    Board Regular
    Join Date
    Oct 2009
    Location
    Midlands, UK
    Posts
    7,509
    Post Thanks / Like
    Mentioned
    17 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Pick random cells

    The analysis toolpak is in file-options-addins. You need it enabled I presume that was saying in dutch.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •