• 412K Members
• 7,605 Online
• 468K Conversations
SOLVED

New Contributor

# 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 want to not "Count" 0, so that the result I get is -2, -1 and 1. Is this possible to write With Excel formula??

3 Replies
Solution

# Re: 3 smallest values

Hi,

That could be like

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

for

# Re: 3 smallest values

Sergei, excelent! Thanks a lot!

best regards Hovard

# Re: 3 smallest values

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies