formula works unless cell value is a 12

[FreakyGirl]

hello

i been testing out a new spreadsheet & for some reason when i enter a 12 as a value in a certain cell it will cause some of the the formulas in another column to turn FALSE therefore displaying wrong results.

i have tried with several other numbers 20, 11, 8, 6, 4 etc & results stay correct.
i tried dragging down the prev row to make sure formatting is correct.
i have draged down the first row of all formulas in spreadsheet to make sure all correct.

i have other 12s thruout the scoring area & there seems to be no problem elsewhere.

the formula thats changing from true to false is as follows:

=AI11&IF(AND(SUMPRODUCT(--($AI$11:$AI$100=AI11),--($J$11:$J$100=J11))=COUNTIF($AI$11:$AI$100,AI11),COUNTIF($AI$11:$AI$100,AI11)>1),I11,99)

this formula looks at the numbers in the previous column. if tied, checks the values in another column to see if those are tied as well. if thats also tied then it will return a value from an adjacent column. if not tied, a 99 is added to the end.

cell thats a problem when a 12 is entered is N19.
cells that change formula when a 12 is displayed: AJ17, AJ18, AJ31, AJ32, AJ33, AJ38 & AJ39.

this is causing a change in the ranked players which you can see in C31, C32, C33 when a 12 is entered over other numbers.

if anyone can find the problem it would be appreciated.

thanks & have a great day!
FreakyGirl

 

[Luke M]

Appears to be working fine to me? I changed cell N19 to 12, all I see are numbers.

 

[FreakyGirl]

when you enter a 12 in N19 the cells in AJ17, AJ18, AJ31, AJ32, AJ33, AJ38 & AJ39 change to 99 from their correct numbers.

enter something other than 12 in N19 get the correct results below

last 2 numbers in AJ17 & AJ18 = 36
last 2 numbers in AJ31 & AJ32 = 44
last 2 numbers in AJ33 = 39
last 2 numbers in AJ38 = 27
last 2 numbers in AJ39 = 25

enter a 12 in N99 last 2 numbers in all cells above turn to 99

thanks,
FreakyGirl