assuming your data (one column range) are in A1:A100
and there are some 0 (blank / zero) value in these column..
try this *Array Formula*
=MIN(IF(A1:A100<>0,A1:A100))
On Wed, Mar 30, 2011 at 3:39 AM, John A. Smith <johnasmit...@gmail.com>wrote:
> Thank you very much. It works great. One other question please; I have a
> column with all formula's and I am looking for the smallest number in it by
> using =MIN(range). I get 0 (zero) because the formula is
> =IF(DY9="GONE","",D9). DY9 is an automatic status column that shows "GONE"
> if a ship date is filled out in a previous column. D9 is the value of the
> shipment yet to ship. =MAX(range) works but it senses the zero if it is
> gone so the =MIN(range) doesn't.
>
> Thank you for your kind teaching help.
>
> John
>
> On Tue, Mar 29, 2011 at 4:17 PM, STDEV(i) <setiyowati.d...@gmail.com>wrote:
>
>> Please try, and check if it helps
>>
>> =IF(COUNT('Dept A:Dept C'!B3)=0,"",AVERAGE('Dept A:Dept C'!B3))
>>
>>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
