Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users Joined: 3/27/2006(UTC) Posts: 41 Location: Singapore
|
Hi Pyradius,
Thanks for your advice to which I had revised the formular to...
Col A: If(Cross(Mov(C,22,E)-Mov(C,50,E),Mov(Mov(C,22,E)-Mov(C,50,E),9,E)),1,If(Cross(Mov(Mov(C,22,E)-Mov(C,50,E),9,E),Mov(C,22,E)-Mov(C,50,E)),-1,0))
Filter: colA=1 OR colA=-1
Thanks once again and Happy New Year To you. Hope you have a wonderful and prosperous year ahead.
Sincerely Roy
|