Forum Discussion
Solved
Extract data using text within set of data
Hi i have a set of data with keywords containing SLS1,SLS2,SLS3....SLS10, ULS1,ULS2....ULS10. i wish to segregate this into separate set of SLS and ULS using certain condition like max axial. For e...
Don't understand why my simple solution shouldn't work. Used Patrick's file to illustrate how it works.
Try this:
=MAX(ISNUMBER(FIND("SLS",C7:C5000))*F7:F5000)