Results 1 to 4 of 4

List/dyn range of nonzero entries

Threaded View

  1. 08-20-2014, 07:27 PM #1
    andredl
    andredl is offline
    Registered User
    Join Date
    08-13-2014
    Location
    Hobart
    MS-Off Ver
    2013
    Posts
    32

    List/dyn range of nonzero entries

    Hi, I have a database containing unique numbers (the database is variable) and want to derive a list of unique, nonzero entries for every row. It would be nice if the output can be a dynamic range.
    Attached Files Attached Files
    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. returning all entries from a percentile range into a new list on separate sheet
    By fingraphics in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-10-2014, 06:02 PM
  2. [SOLVED] Counting nonzero values in a dynamic range
    By guest2013 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-20-2013, 02:49 PM
  3. Using VBA: I have a list with multiple entries.Need to reduce down to unique entries
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-25-2011, 03:19 PM
  4. Condensing a data range with only a few nonzero values???
    By Travis.Broersma in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-09-2006, 05:00 PM
  5. How to compute StDev of only nonzero entries in a range?
    By Sam in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-18-2005, 08:06 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