SMALL function

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Good Morning Eveyrone,
Using Excel XP. I would I write the formula =SMALL(A1:A100) that would find
the lowest numbers that are NOT zeros.
Thanks for you help,
Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Small function 2
Offset and Small functions with blank rows? 0
Conditional Formatting: Highlight Cell that contains soonest Day 6
isblank() function 6
Macro that copies values from column A (from formula) to B (paste value) 1
problem with combining functions 2
SUMing small numbers 6
Discarding zero's 5

Back
Top