chippymark
Board Regular
- Joined
- Aug 2, 2007
- Messages
- 50
Ok well here goes, for those of you advanced I will try to do my best to get across what I am looking to achieve: Please Bear with me.
In what would be Cell E2 I want to post the Total posted set Assuming that the Order Numbers and the OP Numbers are the Same, but only if there is a value in the allowed set,
So I'd expect E2 in the case below to read 1.83, But I would not want double postings ????
Is this feasable or am I expecting too much.
thanks in advance
Mark
Order No OP Posted Set Allowed Set
30761157 0010 0.73 1.500
30761157 0010 0.50 0.000
30761157 0010 0.60 0.000
30764610 0010 0.00 0.000
30764610 0010 1.05 0.500
30765244 0010 0.00 0.000
30765244 0010 0.55 0.500
30766396 0010 0.00 0.000
30766396 0010 1.18 0.500
30768109 0010 0.00 0.000
30768629 0010 0.00 0.000
30768629 0010 0.00 0.000
30768629 0010 0.00 0.000
In what would be Cell E2 I want to post the Total posted set Assuming that the Order Numbers and the OP Numbers are the Same, but only if there is a value in the allowed set,
So I'd expect E2 in the case below to read 1.83, But I would not want double postings ????
Is this feasable or am I expecting too much.
thanks in advance
Mark
Order No OP Posted Set Allowed Set
30761157 0010 0.73 1.500
30761157 0010 0.50 0.000
30761157 0010 0.60 0.000
30764610 0010 0.00 0.000
30764610 0010 1.05 0.500
30765244 0010 0.00 0.000
30765244 0010 0.55 0.500
30766396 0010 0.00 0.000
30766396 0010 1.18 0.500
30768109 0010 0.00 0.000
30768629 0010 0.00 0.000
30768629 0010 0.00 0.000
30768629 0010 0.00 0.000