contains formula
 

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

--
xtrmhype
-----------------------------------------------------------------------
xtrmhyper's Profile: http://www.excelforum.com/member.php...fo&userid=2385
View this thread: http://www.excelforum.com/showthread.php?threadid=55944

contains formula
 

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)

"xtrmhyper" wrote
in message ...

i have 3 row

A B C
xtrm hyper xtrm hype
hyper xtrm asdfd kd


how can i get for the formula of this? if A1 contains the data of b1
c1=ok
else
C1=x

and you may specify the starting letter
for ex. on B1 1st 3 char only that contain in A1
1st 3 char of b1 is xtr hyp

output

A B C
xtrm hyper xtrm hype ok
hyper xtrm asdfd kd x



tnx in advance


--
xtrmhyper
------------------------------------------------------------------------
xtrmhyper's Profile:
http://www.excelforum.com/member.php...o&userid=23851
View this thread: http://www.excelforum.com/showthread...hreadid=559442

contains formula
 

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

"xtrmhyper" wrote:


i have 3 row

A B C
xtrm hyper xtrm hype
hyper xtrm asdfd kd


how can i get for the formula of this? if A1 contains the data of b1
c1=ok
else
C1=x

and you may specify the starting letter
for ex. on B1 1st 3 char only that contain in A1
1st 3 char of b1 is xtr hyp

output

A B C
xtrm hyper xtrm hype ok
hyper xtrm asdfd kd x



tnx in advance


--
xtrmhyper
------------------------------------------------------------------------
xtrmhyper's Profile: http://www.excelforum.com/member.php...o&userid=23851
View this thread: http://www.excelforum.com/showthread...hreadid=559442

contains formula
 

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


"Jim Jackson" wrote:

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

"xtrmhyper" wrote:


i have 3 row

A B C
xtrm hyper xtrm hype
hyper xtrm asdfd kd


how can i get for the formula of this? if A1 contains the data of b1
c1=ok
else
C1=x

and you may specify the starting letter
for ex. on B1 1st 3 char only that contain in A1
1st 3 char of b1 is xtr hyp

output

A B C
xtrm hyper xtrm hype ok
hyper xtrm asdfd kd x



tnx in advance


--
xtrmhyper
------------------------------------------------------------------------
xtrmhyper's Profile: http://www.excelforum.com/member.php...o&userid=23851
View this thread: http://www.excelforum.com/showthread...hreadid=559442

contains formula
 

any formula in excel?
tnx


--
xtrmhyper
------------------------------------------------------------------------
xtrmhyper's Profile: http://www.excelforum.com/member.php...o&userid=23851
View this thread: http://www.excelforum.com/showthread...hreadid=559442

contains formula
 

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
"xtrmhyper" wrote:


any formula in excel?
tnx


--
xtrmhyper
------------------------------------------------------------------------
xtrmhyper's Profile: http://www.excelforum.com/member.php...o&userid=23851
View this thread: http://www.excelforum.com/showthread...hreadid=559442

contains formula
 

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

"Jim Jackson" wrote:

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
"xtrmhyper" wrote:


any formula in excel?
tnx


--
xtrmhyper
------------------------------------------------------------------------
xtrmhyper's Profile: http://www.excelforum.com/member.php...o&userid=23851
View this thread: http://www.excelforum.com/showthread...hreadid=559442

contains formula
 

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


--
xtrmhyper
------------------------------------------------------------------------
xtrmhyper's Profile: http://www.excelforum.com/member.php...o&userid=23851
View this thread: http://www.excelforum.com/showthread...hreadid=559442

contains formula
 

up for this thread:(


--
xtrmhyper
------------------------------------------------------------------------
xtrmhyper's Profile: http://www.excelforum.com/member.php...o&userid=23851
View this thread: http://www.excelforum.com/showthread...hreadid=559442