Microsoft Office Forums - View Single Post - [Solved] Formula, Compare two cell's text and based on results output a number

Thread: [Solved] Formula, Compare two cell's text and based on results output a number

View Single Post

Old

03-15-2016, 09:35 PM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

You are right.
Try to change the formula to:

=IF(K2<>"Medical","",
--SUBSTITUTE(TRIM(IF(COUNT(SEARCH({"A","B","C","D"," E"},D2)),10,"") &IF(COUNT(SEARCH({"F","G","H","I"},D2)),5,"") &IF(COUNT(SEARCH({"J","K","L","M"},D2)),7,"")),"", ","))

Reply With Quote