Need help- Find Function with Multiple criteria

[Mallappa]

Hi everyone,

I need your help for Find Function with Multiple criterias. Ex-

ADC XE AD ADKO R Ad Know Op
ADC XE AD ADKO X Ad Know
ADC XE AD ADKOAd Know
KNE XE KN ACDA

If this is my data in Column A, I need to find the names which contains " R " and " X " in 16th digit. I can do it using find formula twice but is there a way to do it in on shot..?

The formula I'm using is =FIND(" R ",A1,16) it gives me numbers like 16, 17, 19, 20 etc but I'm interested only in 16 digit so I just filter for 16 and copy the data to seperate tab.

Waiting for you ans​

 

[Teethless mama]

=or(mid(a1,16,1)={"r","x"})

 

[Mallappa]

=or(mid(a1,16,1)={"r","x"})

The "R " and "X " are case sensitive so I'm using Find formula. Even space after R or X is to be considered.

 

[T. Valko]

The "R " and "X " are case sensitive so I'm using Find formula. Even space after R or X is to be considered.

Maybe this...

=OR(EXACT(MID(A2,15,3),{" R "," X "}))

Will return either TRUE or FALSE

 

[Mallappa]

Maybe this...

=OR(EXACT(MID(A2,15,3),{" R "," X "}))

Will return either TRUE or FALSE

No doesn't work. Problem with this it is not case sensitive.

 

[T. Valko]

No doesn't work. Problem with this it is not case sensitive.

No, it is case sensitive.

As written the formula must find uppercase " R " or " X ".

Book1
	A	B
2	ADC XE AD ADKO r Ad Know Op	FALSE
3	ADC XE AD ADKO R Ad Know Op	TRUE
4	ADC XE AD ADKO x Ad Know	FALSE
5	ADC XE AD ADKO X Ad Know	TRUE
6	ADC XE AD ADKOAd Know	FALSE
7	KNE XE KN ACDA	FALSE
Sheet1

This formula entered in B2 and copied down:

=OR(EXACT(MID(A2,15,3),{" R "," X "}))

If that's not what you want then we need to see more examples and tell us what results you expect.

 

[Mallappa]

Need help to Combine a formula

Hi Friendsm,

=IF(FIND("X ",$B3,16)=16,"True","False") and =IF(FIND("R ",$B3,16)=16,"True","False")

Can anybody help me to combine these two formula in one. The only change in these two is Find "R " or "X ".

Waiting for ealry reply..!

 

[Mindpsyche]

Re: Need help to Combine a formula

Hi Friendsm,

=IF(FIND("X ",$B3,16)=16,"True","False") and =IF(FIND("R ",$B3,16)=16,"True","False")

Can anybody help me to combine these two formula in one. The only change in these two is Find "R " or "X ".

Waiting for ealry reply..!

Replace A1 with whichever cell you are using as a reference and try this:

=IF(MID(A1,16,1)<>"X",IF(MID(A1,16,1)<>"r",FALSE,TRUE),TRUE)

However, this ignores upper and lower case, so if the 16th character is x or R you will still get a true.

 

[Joe4]

Re: Need help to Combine a formula

I have merged your two threads into one.

The general rule of thumb is that any follow-ups, clarifications, or directly related follow-ups should be posted back to the original thread.
Only start new threads for entirely new questions.

 

[texasalynn]

Re: Need help to Combine a formula

=IF(SEARCH("X ",$B3,16)=16,"True",IF(SEARCH("R ",$B3,16)=16,"True","False"))