Discussions
»
Product and Service Development
»
Formula Assistance
»
Alert function for a single event possible? Who can program this?
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,
|
|
|
|
|
|
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
|
|
|
|
|
|
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 |
|
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
Alert function for a single event possible? Who can program this?
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.
