Maybe one way (but I'm sure there are others),
=IF(SUM(COUNTIF(A1,{"*1R*","*LP*"}))>1,"Both are there","No chance")
Maybe one way (but I'm sure there are others),
=IF(SUM(COUNTIF(A1,{"*1R*","*LP*"}))>1,"Both are there","No chance")
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks