View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default minimum value excluding zero

Check your other post.

mkh wrote:

i have a colourm with values ranging from 0 to 100, i want to find the
minimum value excluding 0

for example, if the row contains 100, 50, 30, 10, 0

the min value shown should be 10

the values are all postive values

thanx


--

Dave Peterson