Help with Function: Compare text and and edit in cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CyranoDeBergarac - 12 Jun 2007 00:53 GMT

Hi,

I need a function that compare text in two cells for a specific text
and if exists make edit the second cell as the first one.

For example my function willl:

1. Look for the text "#" in cell A1.
2. If "#" exists in A1 and there is a letter after it, like "#E", it
will compare it to B1.
3. If the letter after"#" is the same in A1 with B1, it should not do
anything. If the letter after "#" is different in B1 comparing to, it
needs to flag that cell by stating True or False.

Thanks in advance,
Mehmet

Reply to this Message

Vasant Nanavati - 12 Jun 2007 01:37 GMT

Put the following formula in C1:

=MID(A1,FIND("#",A1)+1,1)=MID(B1,FIND("#",B1)+1,1)

Adjust to suit.

Formulas cannot change cells,; if the formula shows FALSE you will have to
change the cell manually or write a macro to accomplish this.

__________________________________________________________________________

> Hi,
>
[quoted text clipped - 12 lines]
> Thanks in advance,
> Mehmet

Reply to this Message

CyranoDeBergarac - 12 Jun 2007 15:52 GMT

> Put the following formula in C1:
>
[quoted text clipped - 25 lines]
>
> - Show quotedtext-

Thanks Vasant, that helps.

Reply to this Message