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​

 

[Mallappa]

Try this...

Sheet1

*	A	B
AD AD ADKO I Acquired Content
SCS XE RE RE__ I Knowledge
SCS XE SC SECO I Knowledge
KNC XE IC CMIO I StrtIntCntPrj
SCM XE TH TECH I Knowledge
KNC XE KN DDOP I Digital Deply
ADC XE AD ADKO R Ad Know Op
ADC XE AD ADKO x Ad Know
ADC XE AD ADKO X Ad Know
ADC XE AD ADKOAd Know
KNE XE KN ACDA
CFT XE CF FLXCFlexsmrComp

<COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 234px"><COL style="WIDTH: 72px"></COLGROUP><TBODY>
[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="align: right"]FALSE[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="align: right"]FALSE[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="align: right"]FALSE[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

[TD="align: right"]FALSE[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]

[TD="align: right"]FALSE[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]

[TD="align: right"]FALSE[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]

[TD="align: right"]TRUE[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]

[TD="align: right"]FALSE[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]

[TD="align: right"]TRUE[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]

[TD="align: right"]FALSE[/TD]

[TD="bgcolor: #cacaca, align: center"]12[/TD]

[TD="align: right"]FALSE[/TD]

[TD="bgcolor: #cacaca, align: center"]13[/TD]
[TD="align: left"]ASL XE AT ASLRIFRSEUDevSMR[/TD]
[TD="align: right"]TRUE[/TD]

[TD="bgcolor: #cacaca, align: center"]14[/TD]

[TD="align: right"]TRUE[/TD]

</TBODY>

This formula entered in B2 and copied down:

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

Cool. It works great. Thank you very very much for your support. I get back to you if I come across any doubts in future.

 

[T. Valko]

Cool. It works great. Thank you very very much for your support. I get back to you if I come across any doubts in future.

You're welcome. Thanks for the feedback!