Hey guys,
I hope you are well.
There is a task where somebody will enter values in column A.
The values are to be entered moving downward along column A starting from A2.
I want only if the adjacent values in column A are equal to each other to return TRUE.
Important case: If i was entering data in column A, the first instance of a new value for example letter B,
so it shall return false in the first time, but when i provide afterwards in its adjacent below cell value B than all is to be returned true for both B values.
Another example, in cell A13 when i entered letter C, it shall return false at its first instance, only when i enter afterwards letter C
in A14 then both shall be true.
Please refer to my excel sheet, because it is much clearer.
Thanks a lot.
Bookmarks