Mar 04 2022 06:20 AM - edited Mar 04 2022 06:22 AM
I need to see how to "fix" the #NUM! error on my spreadsheet.
Once data is entered in the cells it refers to the results are correct. The formula is:
=SMALL(M20:M23,COUNTIF($M$20:$M$23,0)+1)
Mar 04 2022 06:24 AM
=IFERROR(SMALL(M20:M23,COUNTIF($M$20:$M$23,0)+1),"")