Hi, I've tried several methods to exclude zeroes when finding my min.-value.
I've tried array-functions like:
=(if(d1:d7>0,d1:d7))
But I always get an error-message saying that there are wrong in the function.
I've attached my file
Did't wrote the "=" in the function so I could save it.
I'm on office 2008 for mac.
10.6.2
Please help.
Last edited by Ritte; 12-30-2009 at 05:19 PM.
Try
=MIN(IF(G1:G49>0,G1:G49))
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
I still get the error message:
"-If you want help with creating a function click on OK and then Function from the insert-menu.
-If you are not writing a function you should avoid (=) and (-). If you must use these, use a (') before."
Hi
This is array function and must be entered with <ctrl>+<Shift>+<Enter> key combinations
Just copy the formulae and paste it in G52 and confirm it by pressing <Ctrl>+<Shift>+<Enter>
Yes, I'm on mac so it's command + enter.
Still get the problem.
AAaa, u'r using Mac
I misread thism sorry, sorry 1000 times. Actually I never used Mac
Tried on my sisters computer (windows 7, office 2007).
I'm still getting the message.
Can you be kind to write a small sheet with the funtcion so I can see if function thatway?
Would be very nice of you.
See attached
In G52 I used this formula
=MIN(IF(G1:G49>0,G1:G49))
confirmed with CTRL+SHIFT+ENTER
and in G53 I used this non-array version
=SMALL(G1:G49,COUNTIF(G1:G49,0)+1)
That will give the same result assuming you don't have negative numbers
Thanks daddy.
G53 did the trick!
Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks