Results 1 to 3 of 3

Randomly Select from a table with blank cell

Threaded View

  1. 10-31-2013, 01:22 AM #1
    mdyy1399
    mdyy1399 is offline
    Registered User
    Join Date
    10-31-2013
    Location
    Champaign,IL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Randomly Select from a table with blank cell

    I am trying to randomly select 10 data from a table by using index formula. But there are some blank cell in the table so It kept returning 0 in the cell. Do need some help with this plz!problem.xlsx
    Thank you so much!
    Last edited by mdyy1399; 10-31-2013 at 01:25 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Select all the values other than blank and 0 in a pivot table
    By vpnvipin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2013, 09:05 AM
  2. [SOLVED] Code to randomly select from a list based on Cell text value inptted
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2013, 05:57 PM
  3. VBA to Randomly Select a Cell
    By Jiptastic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2013, 10:57 AM
  4. [SOLVED] Select next blank row in table of data
    By adam2308 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2012, 09:01 AM
  5. Select table rows based on is not blank
    By reillc01 in forum Excel General
    Replies: 0
    Last Post: 12-02-2010, 11:22 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1