#1   Report Post  
Douglas McDonald
 
Posts: n/a
Default MIN or DMIN ?

I need to find the min in a column but don't want (0's) zeros
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

If there are no negative values

=LARGE(A1:A30,COUNTIF(A1:A30,"0"))

if there are negative values

=MIN(IF(A1:A30<0,A1:A30))

the latter needs to be entered with ctrl + shift & enter

Regards,

Peo Sjoblom

"Douglas McDonald" wrote:

I need to find the min in a column but don't want (0's) zeros

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Function DMIN? Function Question Excel Worksheet Functions 3 November 20th 04 01:46 AM


All times are GMT +1. The time now is 07:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"