Do not change serial number if same value found

[HaroonSid]

hi,
i am generating my serial number with multiple criteria,

now i want to add one more criteria if column H found same value and column K have any value from this list ("4 OL BC" OR "5 OL J", OR "6 OL JT) Then repeat the same number and don't change the serial number

i just add manual number in Column(AS)
as i need

hope some one will help

I Tried a formula in column(AZ) but no result

Capture.PNG

[Bo_Ry]

Please try at AK3

=IF(AM3=AM2,IF(ISNUMBER(FIND(K3,"4 OL BC 5 OL J 6 OL JT"))*(H3=H2),AK2,AK2+1),INDEX($AL$2:$BA$2,MATCH(AM3,$AK$2:$AZ$2,)))

[HaroonSid]

thank you sir Bo_Ry
i will check and feed back

[HaroonSid]

Please try at AK3

=IF(AM3=AM2,IF(ISNUMBER(FIND(K3,"4 OL BC 5 OL J 6 OL JT"))*(H3=H2),AK2,AK2+1),INDEX($AL$2:$BA$2,MATCH(AM3,$AK$2:$AZ$2,)))

Perfectly working sir

thanks once again