Hi All,
I have a strange problem where I would like to search for a value, such as "K" in a Column and return the value of the cell below it.
i.e.
Column would contain the following data:
A
K
T
J
E
K
A
So in another column, the values returned would be T and A and so on...
Hoping someone...