For J3:
IF(A3=A2) && the occurrence of an entry in F3 is for the first time THEN (J3=(20-(F2+F3))/20)
ELSE J3=J2 - I3.
For J4:
IF(A4=A3 & A3=A2) && the occurrence of an entry in F4 is for the first time THEN (J4=(20-(F2+F3+F4))/20)
ELSE J4=J3 - I4.
But if,
IF (A4=A3) but A3 (is not eaual) != A2) && the occurrence of an entry in F4 is for the first time THEN (J4=(20-(F3+F4))/20)
ELSE J4=J3 - I4.
Similarly,
For J5:
IF(A5=A4 & A4=A3& A3=A2) && the occurrence of an entry in F5 is for the first time THEN (J5= (20-(F2+F3+F4))/20)
ELSE J5=J4 - I5.
But if,
IF (A5=A4 & A4=A3) but A3 (is not eaual) != A2) && the occurrence of an entry in F5 is for the first time THEN (J4=(20-(F3+F4))/20)
ELSE J4=J3 - I4.
and so on...
Note :In the above mentioned formual, it should add up values in F only if, the values in A are identical.
So ideally, in J6 I should be getting the result as (90.91-2.73) i.e J5-I6.
Bookmarks