Forum Discussion
Extract data using text within set of data
Don't understand why my simple solution shouldn't work. Used Patrick's file to illustrate how it works.
Hi Patrick
Thanks for your reply it sort of works but not exactly what I'm looking for. in your excel you are putting the formula in G3, hit enter and it extracts the substrings from col D and displays the corresponding function (max) in front of it in col H. What i need is to use a formula in cell H3 that reads entries in col D with substring "SLS" and returns the maximum value from col E corresponding to those entries. It need not 'spill'.
I think we may have a difference in philosophy here. I believe in spilling whenever possible - entire results in a single input. Things become more difficult when we're trying to fit a solution in a space.