Thread: Line adherence
View Single Post
  #4   Report Post  
Jay
 
Posts: n/a
Default

I would to make a formula for O column in order to include
results of x1,x2,x3,...

suppose we have a list like that

e3:e789 n3:n789 O3:O789
Drawing no on time delivery
x1 1 0
x1 0
x1 1
x2 1 0
x2 0
x2 1
x3 1 1
x3 1
x4 0 0

o3:n3*n4*n5..........as the result of x1
o6:n6*n7*n8..........as the result of x2
o9:n9*n10.............as the result of x3
o11:n11................as the result of x4


One way:

In P3 put
=N3*IF(E3=E4,P4,1)
and copy down.

In O3 put
=IF(E3=E2,"",P3)
and copy down.

You can hide column P if need be.