Formula or code?

  • Thread starter Thread starter Mistry
  • Start date Start date
M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula or code? 4
IF? Vlookup? 2
Formula or VB? 1
CMOS failure - Asus P8Z68-V LX 10
SUMPRODUCT within set dates 4
sumif? 6
The Overclocked Performance of the mini-ITX H55 MB form ECS H55H-I 4
RAID 1 & new mobo 5

Back
Top