Results 1 to 4 of 4

Find Smallest X Value For A Group Ignoring Zeros

Threaded View

  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    USA
    MS-Off Ver
    2019 16.0.13205.200000 64-bit
    Posts
    61

    Find Smallest X Value For A Group Ignoring Zeros

    I have a trivial, hopefully, issue: I need to find several smallest data points for a certain group of values. I got an array formula, but I'm having a bit of a hard time making it ignore zero values completely. Here's the formula:
    =SMALL(IF($A$2:$A$14=$A$14,$B$2:$B$14),1)
    $A$2:$A$14 - column with group values
    $B$2:$B$14 - where data points are stored
    $A$14 - a name of a group
    It's giving me zero values if there are any in the data, and I'd like to start with the smallest above-zero values.

    Any ideas, guys/gals? Thanks so much in advance!

    Sample file is attached as well.
    Attached Files Attached Files
    Last edited by splendidus; 06-11-2012 at 12:26 PM.
    Office 2019 16.0.13205.200000 64-bit

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