Hi, I've created an example spreadsheet of what I'm looking to do.
I need the contents of Column A to be sorted (Example output, Column C), based on the input text contained within Column B.
I am still pretty new to excel and haven't been able to figure this out. I've tried XLOOKUP, but that doesn't seem to do what I need here.
Column B contains a string of text that exists in each cell on Column A. "dll" exists in A3, for example. What I want is to basically sort A2, A3, and A4 using B2, B3 and B4 as a guide. This would be output as seen on Column C.
Hopefully this is possible, thank you for any help you can provide!
Bookmarks