Determine a change in value

[delali]

Hi,
is there a way to eveluate a range of cells and determine
where the value of the cells change.
example range A1 to A10 contains countries. A1 to A6
contain CANADA and A7 to A10 contain USA. i want to be
able to determine that the values changed at A7

thank you

 

[Frank Kabel]

Hi
enter the following formula in B2:
=IF(A1<>A2,"Changed value","")
and copy this down