MIN to find specific lowest value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

my data:
0
0
0
0
..01
..93
..03
I need to find the lowest value NOT including 0.
help with formula please..... thank you! jane
 
how about a nice array formula which must be entered/edited with
ctrl+shift+enter

=MIN(IF(M2:M22>0,M2:M22))
 
Hi Don,
I tried the enter the formula at the end of my column but received #VALUE!.
can you clarify what you mean by enter/ edit the array by using shift control
enter?
thank you, jane
 
An "array" formula must be entered/edited with ctrl+shift+enter vs only
using the enter key. So when you create or change this formula hold down the
control key and the shift key and touch the enter key. you will then see
{ } around the formula. This must be done whenever you make a change
but NOT when copying down.
 
Thank you Don!

I got it!

appreciate your time and information.... jane
 
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

Trying to find additional ranges outside of min, max, and average 2
Access Running Balance in Access 1
Trying to subtract the two lowest values from a row of numbers 4
MIN 2
Conditional Formating: MAX & MIN 3
Looking up name with 2 criteria 5
Rank and Sort 4
lowest figure greater than 1 4

Back
Top