Hello,
i want to compare a column's cell to check for variation. The column it self has several parts and therefore is split using coloured cells. There are no variations allowed in each section.
eg. Using this as an example
Yellow coloured cell
ab
ab
ab
ab
Yellow coloured cell
ab
ab
ab
zz
ab
yellow coloured cell
green coloured cell
aa
aa
aa
aa
yellow coloured cell
This first section is fine. The second section should be flagged as they aren't the same. The third section is fine too.
Thanks in advance
i want to compare a column's cell to check for variation. The column it self has several parts and therefore is split using coloured cells. There are no variations allowed in each section.
eg. Using this as an example
Yellow coloured cell
ab
ab
ab
ab
Yellow coloured cell
ab
ab
ab
zz
ab
yellow coloured cell
green coloured cell
aa
aa
aa
aa
yellow coloured cell
This first section is fine. The second section should be flagged as they aren't the same. The third section is fine too.
Thanks in advance