thx arthur,

it works. However, I still counter a problem here.

For example.
Colum A to J
Value 1 1 1 a 1 1 b 1 1 a

Then If I use your formula, it works. However, then I want to change value "a" to "1" if within that range have 2 "A"

Is it possible?

Thank you.