I’m trying to construct some formulas in Excel 2007 to sort some data and I’m just having trouble implementing a suitable sorting algorithm that gives me the result I want.
My data looks a bit like this:
3.0 K, FWHM=0.4
After sorting it needs to look like this:
3.0 K, FWHM=0.4 (if this is swapped with the one above it doesn’t matter)
An alphabetical sort doesn’t work once I have numbers above 10. I’ve had some success using the Left and Search functions to extract out the initial numbers, then using the Small function to give me a numerical sort of this second set, but I can’t seem to get a working method to use this second set to sort the first. The 3.0 K vs 3.0 K, FWHM=0.4 data is giving me some problems in relation to this.
Any idea how I can accomplish this sort? I don’t mind if I have to do it via multiple steps, however I cannot use the sort wizard, only formulas, as the former is not suitable for this application in the context of the rest of my workbook.
Thanks in advance for any help you can offer.