Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |