3 smallest values

[hbrand]

Hi, example. I have a list of the folloming numbers.

-2, -1, 0, 1, 2, 3

I want to use a formula to find the 3 lowest vaules. If I use n.small 1, 2 and 3, a get the answer -2, -1 and 0. But I want to not "Count" 0, so that the result I get is -2, -1 and 1. Is this possible to write With Excel formula??

[#2 · Accepted solution]

Hi,

That could be like

=AGGREGATE(15,6,$A$1:$A$6/($A$1:$A$6<>0),C1)

for

[#3]

Sergei, excelent! Thanks a lot!

best regards Hovard

[#4]

Hovard, glad to help