Line adherence

[exile]

Hi all

I have multiple similar autofiltered worksheets in a workbook as like
below.
My goal is calculating Line adherence(LA) and Quantity adherence(QA).
Quantity adherence very simple to me.

QA=SUBTOTAL(9;N3:N789)/=SUBTOTAL(3;N3:N789)
QA:6/8

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

---------------------------------------------

I have array formula for unique items for total line , for this sample
is 3(x1,x2,x3) with ctrl+shft+enter

=SUM(1/MMULT((IF(((M3:M789)=N1);E3:E789)=TRANSPOSE(IF(((M3:M789)=N1);E3:E789)))+0;ROW(E3:E789)^0))-1

Line is 1 for above sample on column O
x1:1*0*1.......0
x2:1*0*1.......0
x3:1*1.........1
LA:1/3

I couldn't get any formula for column O ?

I appreciate any help given,
thank you.

 

[exile]

hi again

I thought that I couldn't explain my question well enough as there were
no responses so let's try it again.

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


and it goes on like that...

i would be pleased if you could help

thanks

 

[exile]

Is this really so hard question or you can not understand or ??.
This is really important and urgent for me, If I found any solution, I
will appreciate.

 

[Jay]

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.

 

[exile]

Thanks a billion.Wonderfull.