+ Reply to Thread
Results 1 to 2 of 2

Selecting a Random Blank Cell Within a Partially Populated 100 Cell Block Pool

  1. #1
    Registered User
    Join Date
    09-07-2012
    Location
    Philadelphia
    MS-Off Ver
    Excel 2010
    Posts
    12

    Selecting a Random Blank Cell Within a Partially Populated 100 Cell Block Pool

    Hi All,

    With playoff football in full swing, I'm looking for some formula help to randomly pick a blank cell within a 100 count/cell block pool. Figured I would try something different this year and have excel pick my blocks for me...

    I tried playing around with RANDBETWEEN formula, but I'm not sure how I can specify that I want the formula to randomly pick only a blank cell that isn't already taken in the block pool.

    Anyone have a quick solution? I did try searching online but I wasn't successful in finding exactly what I'm looking to do - I know someone on here can help me out quickly!

    Also, I want to be able to use the formula to pick 4 block for me..again, picking only blocks/cells that are blank.

    For context, the block pool range is: D5:M14.

    Thanks!

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Selecting a Random Blank Cell Within a Partially Populated 100 Cell Block Pool

    Try this

    Please Login or Register  to view this content.
    Martin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Issue with selecting random blank cell in range
    By ARowbot in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-26-2018, 01:50 PM
  2. [SOLVED] If two cells are blank then return blank, else vlookup cell with populated data
    By Jason G in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-06-2017, 10:20 AM
  3. Round 2, best way to make a cell blank until another cell is populated?
    By bultm35431 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-16-2016, 11:03 PM
  4. Assign fixed value to blank cell if adjacent cell is populated.
    By Eric P. in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-15-2015, 08:36 AM
  5. Replies: 9
    Last Post: 12-09-2011, 04:39 AM
  6. Replies: 2
    Last Post: 01-09-2011, 01:24 PM
  7. selecting only populated cell problem
    By Hammer_757 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2009, 11:23 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1