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.
the intent is that F4 should identify from col B which have substring "SLS" and return max value among those cases (SLS1,SLS2,SLS3,SLS4 etc). similarly for ULS
I understand the intent. My point is that I can't test and offer a solution without some data.