Small Ignore zero and negative numbers

Hi Excelski,

Allan Wyatt has a web page with this question and I assume the answer you want.

https://excel.tips.net/T003260_Retur...ero_Value.html

If this doesn't help then attach a sample worksheet so we can see the problem.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi,

Often by using an array formula to grab the non zero and non negatived before wrapping the Array formula in a SMALL() function.

For more specific help please upload the workbook.

Hi,

You were asking for the smallest so not quite sure why your example shows the largest and smallest. However

Formula:

Please Login or Register  to view this content.

Entered as an array formula with Ctrl-Shift-ENter will return 25

Originally Posted by Excelski

Hi,
My ultimate goal is to find the smallest to the largest number in order, ignoring zeros and negative numbers.
I find I learn more if I don't ask for the complete answers and apply the solutions offered as part of the whole soultion

Thanks
Kevin

That's all very well but as the providers of help we often find ourselves on a contantly winding path when the OP adds some other factor that completely negates the solution given which then needs to be added to or done away with completely and a new approach used.

That may not be the case here but please remember for the future. We like to understand all the requrements and what the end goal is

That said can I assume you can now adapt the solution you've been given to determine the largest number? In which case please mark the thread as solved.