ABFARAD TRUE
DAGABAS TRUE
BAHADAS TRUE
BAJADAS TRUE
LAMBADA TRUE
BANDANA TRUE
CADAGAS TRUE
MACADAM
I have this on a1 need formula on b1 to mark me true if it finds any two letters quoted as DLNTRS , those are the expected results , it wont mark the MACADAM
I have this formula that find one letter search using else where
Please Login or Register to view this content.
in C1
=IF(SUMPRODUCT(--(ISNUMBER(SEARCH((MID("DLNTRS",ROW(INDIRECT("1:6")),1)),A1))))=2,TRUE,FALSE)
and copy down the column
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thank you Special-K , working as exactly needed
Looks to be working but it not mark these , not sure why ?
ALBATAS
ATABALS
BALATAS
Does the formula need and amendment , since in here there are L and T and S , all on search , maybe it needs to understand when it finds any 2 or even any 3
Try
=IF(SUMPRODUCT(--(ISNUMBER(SEARCH((MID("DLNTRS",ROW(INDIRECT("1:6")),1)),A9))))>=2,TRUE,FALSE)
Last edited by JohnTopley; 02-13-2017 at 01:54 PM.
John works , with that small additional of greater sign
Thank you too
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks