Formula or code?

[Mistry]

I have 3 bits of data.

I need 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.

 

[Jim Cone]

Also asked in the public.excel.programming group.


"Mistry" <[email protected]>
wrote in message
news:f5dd92ba-2a96-4a3d-a8de-25700853b5ae@b18g2000vbz.googlegroups.com...

 

[Mistry]

Also asked in the public.excel.programming group.

"Mistry" <[email protected]>
wrote in message





- Show quoted text -

Sorry didnt realise they would be in the same group.