contains formula

[xtrmhyper]

i have 3 row

A B
xtrm hyper xtrm hyp
hyper xtrm asdfd k

how can i get for the formula of this? if A1 contains the data of b
c1=o
els
C1=

and you may specify the starting lette
for ex. on B1 >> 1st 3 char only that contain in A
1st 3 char of b1 is xtr hy

outpu

A B
xtrm hyper xtrm hype o
hyper xtrm asdfd kd


tnx in advanc

 

[Bob Phillips]

First part

=IF(A1=B1,"Ok","")

Don't get the second part.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

I would try:

Range("B1").activate
For each cell in sheets
Do
If instr(Activecell) like Activecell.offset(0'-1) then
Activecell.offset(0,1) = "ok"
else
Activecell.offset(0,1) = "x"
end if
activecell.offset(1,0).activate
loop
next

Best wishes,

Jim

 

[Guest]

Change "If instr(Activecell) like Activecell.offset(0'-1) then"
to
"If instr(Activecell) like Activecell.offset(0 , -1) then"

I missed a typo when sending.

Jim

 

[xtrmhyper]

any formula in excel?
tnx

 

[Guest]

Sorry about misunderstanding your request.

If the identical data is always on the left, this will work:

=IF(LEFT(A1,) = LEFT(B1,),"ok","x")

I tried it on the first pair, leaving the number of characters blank and got
the correct response.

=IF(MID(A1,1,) = MID(B1,1,),"ok","x") seems to work if the identical sets
are in different locations withint their respective cells.

Let me know if it works for you as it did for me.

Best wishes,

Jim

 

[Guest]

After further experimentation, I found that the "mid" formula does not work.
It either returns "ok" for everything or, when adjustments are attempted,
returns "x" for everything. I will keep trying and will report anything that
does work.

Sorry about that.

Jim

 

[xtrmhyper]

its not work sir! answer is laways <ok> if it is contain data or not

 

[xtrmhyper]

up for this thread