Forum Discussion
Solved
3 smallest values
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 wan...
Hi,
That could be like
=AGGREGATE(15,6,$A$1:$A$6/($A$1:$A$6<>0),C1)
for
Hi,
That could be like
=AGGREGATE(15,6,$A$1:$A$6/($A$1:$A$6<>0),C1)
for
Sergei, excelent! Thanks a lot!
best regards Hovard
Hovard, glad to help