+ Reply to Thread
Results 1 to 4 of 4

P:L:E:A:S:E !!! Help! Cannot remove blank cells

  1. #1
    Registered User
    Join Date
    12-20-2012
    Location
    America
    MS-Off Ver
    Excel 2003
    Posts
    2

    P:L:E:A:S:E !!! Help! Cannot remove blank cells

    Hi everybody,
    I'm new here.
    I need the formula that can randomly pick up a word from the specific list and put it in a cell. I have some issues with excel formula that I have: =INDEX(List!A2:A7,ROUND(RAND()*COUNTA(List!A2:A7),0))
    It does random, but it doesn't ignore blank cells. (it shows me: #Value! -when it hit a blank cell)
    Example what I need:
    A1: Food:
    A2: Hamburger
    A3: Pizza
    A4: Ice-cream
    A5: (it could be a blank cell)
    A6: (it could be a blank cell)
    A7: (it could be a blank cell)

    This list will be changing a lot.


    P.S. I've attached a file. If you need to see this problem.


    Please I really need your help.
    Thank in advanced.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-27-2012
    Location
    London, England
    MS-Off Ver
    2003, 2010
    Posts
    344

    Re: P:L:E:A:S:E !!! Help! Cannot remove blank cells

    Try this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Just saying to show blank if the formula returns an error.

    Hope this helps.
    If solved kindly remember to mark Thread as solved.
    Click the small star icon at the bottom left of my post if this was useful.

  3. #3
    Registered User
    Join Date
    12-20-2012
    Location
    America
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: P:L:E:A:S:E !!! Help! Cannot remove blank cells

    Thank you very very much! It's really works!!! And thank you for the quick response!

  4. #4
    Forum Contributor
    Join Date
    09-27-2012
    Location
    London, England
    MS-Off Ver
    2003, 2010
    Posts
    344

    Re: P:L:E:A:S:E !!! Help! Cannot remove blank cells

    You are welcome, please mark the thread as Solved...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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