logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
exito100  
#1 Posted : Wednesday, May 26, 2010 7:40:23 AM(UTC)
exito100

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/2/2009(UTC)
Posts: 31

Hello everyone, I am looking for an Alert function that signals +1 if a condition is true only once (exactly 1 time) during a given period. E.g. Alert(C>O,10) is 1 if C>O at least once which is not what I need.. Can anyone do this - preferably without prev? Many thanks,
mstt  
#2 Posted : Wednesday, May 26, 2010 2:46:10 PM(UTC)
mstt

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042

Was thanked: 57 time(s) in 54 post(s)

Hi Exito

Try "Sum(C>O,10)=1".

Roy

exito100  
#3 Posted : Thursday, May 27, 2010 4:57:42 AM(UTC)
exito100

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/2/2009(UTC)
Posts: 31

Many thanks Roy! I feel slightly embarrassed though. Well, all I can say to my defense I had only 3 hours sleep the night before I posted this question.. still... There may be some other underslept MS users out there who may find this post useful - though I recommend postpone programming for a day in that case - which is what I did... Klaus
Users browsing this topic
Guest (Hidden)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.