Hi
Absolutely no idea what you want.
regards
Paul


On Feb 16, 1:51*pm, WYMMIY wrote:
I have 3 bits of data.

Ineed it to check the entire column to see if any of the data matches
and it so provide a EC-x in the appropriate col so in the example
below.
* * * * * * * * Col1 * * * * * * * * * *Col2 * * * * * * * * *Col3
Row 1 * EC * * * * * * *QWERTY * * * POIUY
Row 2 * (EC-x) * * * *ZXCVB * * * * *QWERTY
RO3 * * *EC * * * * * * *lkjhg * * * * * * *ZXCVB
* *.....
Row 4 * * (EC-x) * * * * *rtyui * * * * * * QWERTY
Ro4 * * * *(EC-X) * * * * asdfg * * * * * * *lkjhg

After it has placed the EC-x into the fields i want to be able to
replicate the formula to check if there is a EC-x next to it to then
put a EC-1 and so on and so forth.