L
lehigh
Hi All
I FORGOT TO MENTION THAT SOME OF THE CODES HAVE TWO CHARACTORS
I FORGOT TO MENTION THAT SOME OF THE CODES HAVE TWO CHARACTORS
F
Frank Kabel
Hi
please stay in the original thread
The formula should work also for 2 letter codes.
please stay in the original thread
The formula should work also for 2 letter codes.
L
lehigh
Sorry for the miss post.
If I have an S7 within the contractors code, it will return an "X"
under S and also under S7
Is there a fix for this?
Thanks for your help
If I have an S7 within the contractors code, it will return an "X"
under S and also under S7
Is there a fix for this?
Thanks for your help
F
Frank Kabel
Hi
try
=IF(ISNUMBER(FIND(C$1,$B2)),"X","")
try the following
=IF(LEN(C$1)=2,IF(ISNUMBER(FIND(C$1,$B2)),"X",""),IF(ISNUMBER(FIND(C$1&
" ",SUBSTITUTE($B2,","," ")&" ")),"X",""))
try
=IF(ISNUMBER(FIND(C$1,$B2)),"X","")
try the following
=IF(LEN(C$1)=2,IF(ISNUMBER(FIND(C$1,$B2)),"X",""),IF(ISNUMBER(FIND(C$1&
" ",SUBSTITUTE($B2,","," ")&" ")),"X",""))