Thread: Logic behind this formula

Thanks for the information. But in that case, I don't understand why the formula I'm using in L13 doesn't give me the correct result. Could you tell me whats wrong with this?

=(220-(COUNTIF($A$2:A13,A13)=COUNT($A$2:A13))*SUM($H$2:H12)-H13)/220

Since, the value in A has changed to 2, as per the logic it should give the result as 81.82%.
I've a similar problem with the formula in N13.

Originally Posted by zbor

And as you move down it will tell you when that number is change so that would be breaking point when in range it stop to be old number.

1	TRUE
1	TRUE
1	TRUE
1	TRUE
1	TRUE
2	FALSE
2	FALSE
2	FALSE
2	FALSE
2	FALSE
2	FALSE
3	FALSE
3	FALSE
3	FALSE
3	FALSE
2	FALSE
2	FALSE