cell.value comply with cell.value before and cell.value after
 

Hi Expert,

In column C which is sorted based on column D, groups of words
emerge. Occasionally a
deviant word occurs within such a group of uniform words, eg.:

row column C
1 Word
2 Word
3 Word
4 ord
5 Word
6 Word
7 From
8 From
etc. etc.

Is there some way I can make 'ord' like 'Word' and loop through the
whole of Column C to fix similar situations.
The condition is that ord lies between two similar words, 'Word'. When
row 7 starts with a new group of Words, eg From, this From word will
be left untouched.


Would be happy if you could share some knowledge
ppeer