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: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.![]()
=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
Any ideas, guys/gals? Thanks so much in advance!
Sample file is attached as well.
Bookmarks