Perform Double IF , if True plug Y

[makinmomb]

If B has any of the 3 letters DLNTRS
AND
If B last letter has S , plug Y
OTHERWISE
leave blank

Manually entered those Y , need through formula

[AliGW]

Once again, you have failed to provide mocked up results, as far as I can see, and your description of what you want, yet again, is somewhat cryptic.

SHOW us what you want: MANUALLY add your expected results to the sample file, please.

You really do need to make a bit more of an effort to help us to help you.

[etaf]

EDIT
Notice the same question has been posted re expected results

this should work
=AND(SUMPRODUCT(--ISNUMBER(SEARCH(MID(B1,ROW(INDIRECT("b$1:b"&LEN(B1))),1),"dlntrs")))>=3,RIGHT(B1,1)="S")
BUT it will count
any letter more than once , which you did not show in your example
so
DDD = 3
and will count
so
SSS will give a TRUE result

[makinmomb]

Etaf has got me beyond correct , I cannot write a better ENGLISH than this

If B has any of the 3 letters DLNTRS
AND
If B last letter has S , plug Y
OTHERWISE
leave blank

Etaf will leave the thread open , since any of those letters appearing 1 not twice nor thrice

[etaf]

hence AliGW comments

SHOW us what you want: MANUALLY add your expected results to the sample file, please.

and mine
you need to give the examples in the spreadsheet and perhaps show why

[AliGW]

I cannot write a better ENGLISH than this

All the more reason for you to SHOW us what you want - mock it up NOW, please.

Etaf has got me beyond correct

When someone 'gets' you, it's because you got lucky, not because your description was clear. I take offence at your implication that anyone who doesn't 'get' you straight away is rather inadequate. It is your descriptions and poor sample workbooks that are inadequate: this should come as no surprise to you, since we have been banging on about it for quite some time now.

[makinmomb]

SHAHADAS
SADHANAS
Y MADRASAS
MADRASSA
Y SARDANAS
BADASSED
BADASSES
Y SUBADARS

I put Y on those as it has 3 letters for once for any of the DLNTRS for the first 7 letters , appearing ONCE and that it has an additional S at the end , is this now understood ?

[AliGW]

In the SAMPLE FILE, add your MANUALLY calculated results. Then attach the workbook again. Is this now understood?

[makinmomb]

See attached with closer explained

FIND DLNTRS in the words appearing for a minimum of 3 times , check last letter if S , plug Y

[makinmomb]

ALIG you are being to hard on me , many have understood what i meant

[AliGW]

Thank you. Next time, provide this sort of sample file at the BEGINNING of the thread, please.

ALIG you are being to hard on me , many have understood what i meant

No, I'm not. Many (including me!!!) have understood what you meant EVENTUALLY, but in MANY of your threads, that understanding has NOT been immediate. I am trying to get you to make your opening posts and particularly your sample files more helpful. You have now added a useful workbook to this thread: you could have done this right at the start of the thread.

[JohnTopley]

Please Login or Register  to view this content.

[makinmomb]

Thank you J Topley , leaving thread open , see if formula gives adjacent answers over senior macro man

[makinmomb]

Thread open for formula

[JeteMc]

Here is a formula based solution that employs seven helper columns which may be moved and/or hidden for aesthetic purposes.
1. The letters DLNTRS are placed in cells O1:T1 and the letter S is placed in cell V1
2. O2:T565 are populated using: =ISNUMBER(SEARCH(O$1,$B2))
3. V2:V565 are populated using: =RIGHT(B2,1)=V$1
4. K2:K565 are populated using: =IF(AND(COUNTIFS(O2:T2,TRUE)>=3,V2),"Y","")
Note that the values in K2:K565 match the values that were manually placed in J2:J565.
Let us know if you have any questions.

[John Vergara]

Hi to all!

Another option, with a single formula, could be:

=IF(AND(COUNT(SEARCH({"D","L","N","T","R","S"},B1))>2,RIGHT(B1)="S"),"Y","")  

Drag it down. Blessings!

[makinmomb]

John V , formula handy for me , thank you

[makinmomb]

John the formula does not count occurance , it plugs Y for DOPATTAS , John working is also plugging Y to that which i don't know , those any 3 letters for occur once , thread still open curious if there is a formula version on this

[John Vergara]

Hi makinmomb.

DOPATTAS has three match letters. That is not a Y because has two T ?
TOSTADAS has three match letters. That is not a Y because has two T ?

Please explain better. I don't understand. Put representative examples by hand and explain why is Y and why don't is Y. Help us to help you. Blessings!

[makinmomb]

Three TRUE for It must appear once , not TT for DOPATTS and not TT for TOSTADAS