Determine a change in value

  • Thread starter Thread starter delali
  • Start date Start date
D

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
 
Hi
enter the following formula in B2:
=IF(A1<>A2,"Changed value","")
and copy this down
 
Back
Top