Issue with LARGE formula and zero values

[mcmuney]

Hi, I'm using a LARGE formula to show Top3 and Bottom3 on a set of data that does not fall in a range (hence, individual sells are referenced):

=LARGE((MTD!$L$18,MTD!$L$20,MTD!$L$41,MTD!$L$71,MTD!$L$89,MTD!$L$101,MTD!$L$103,MTD!$L$105,MTD!$L$107,MTD!$L$111,MTD!$L$113,MTD!$L$119,MTD!$L$133,MTD!$L$154,MTD!$L$158,MTD!$L$162,MTD!$L$164,MTD!$L$168,MTD!$L$171,MTD!$L$173,MTD!$L$175,MTD!$L$179,MTD!$L$212,MTD!$L$220,MTD!$L$226,MTD!$L$233,MTD!$L$244,MTD!$L$251,MTD!$L$256,MTD!$L$258,MTD!$L$262,MTD!$L$266,MTD!$L$291,MTD!$L$296,MTD!$L$301,MTD!$L$306),D30)

In total, there are 36 rows involved. It has worked so far, until now, when I have zero values. As a result, my Bottom3 values are repeating, showing the same 0 value.

My Bottom3 are 36, 35, and 34.

How do I solve this problem?

Thanks.

 

[DRSteele]

Use function AGGREGATE to circumvent the problem of finding minimum non-zero numbers. Watch this video on the ExcelIsFun channel to get some insight.

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://www.youtube.com/watch?v=u7B__903dUQ&t=3s&index=3&list=PL3bD6Gu43OtjiWWqhjrxgWNyMYtik4Ore[/FONT]