Pull 10 smallest values, ignore zeros

[virtuosok]

Hi,
I have the following formula to pull top-10 entries from the list, along with entries in associated column. It works well for my purposes.

=SORT(FILTER(CHOOSE({1,2},Source!$B$2:$B$500,Source!$N$2:$N$500),Source!$N$2:$N$500>=LARGE(Source!$N$2:$N$500,10)),2,-1)

How do I repurpose it from LARGE to SMALL, so that it also ignores any zeros in column N? I.e. it starts from ~0.0000000000001 and then pulls 10 lowest values in order, just as the above formula does for 10 biggest ones?

 

[JamesCanale]

You seem to have Office 365 at your disposal.

Mr Excel Playground 3.xlsm
	C	D
11	Numbers	10 smallest
12	5	1
13	0	2
14	10	2
15	15	4
16	0	4
17	2	5
18	20	5
19	21	6
20	20	7
21	0	10
22	4
23	6
24	7
25	4
26	1
27	2
28	0
29	5
30	15
Sheet16

Cell Formulas
Range	Formula
D12:D21	D12	=SMALL(FILTER(C12:C30,C12:C30<>0,""),SEQUENCE(10,1,1,1))
Dynamic array formulas.

 

[Fluff]

How about

=INDEX(SORT(FILTER(CHOOSE({1,2},Source!$B$2:$B$500,Source!$N$2:$N$500),Source!$N$2:$N$500>0),2,1),SEQUENCE(10),{1,2})

 

[virtuosok]

OK great, thank you Fluff - your solution (as usual) is awesome and works seamlessly!
JamesCanale - thanks for the other option, it's not quite what I needed but I'll keep the formula for other needs!

 

[Fluff]

Glad we could help & thanks for the feedback.