{"id":15588,"date":"2021-12-19T14:44:56","date_gmt":"2021-12-19T14:44:56","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=15588"},"modified":"2021-12-19T14:46:44","modified_gmt":"2021-12-19T14:46:44","slug":"solved-sort-algorithm-in-excel","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/sort-algorithm-in-excel\/18546.html","title":{"rendered":"Solved Sort Algorithm In Excel"},"content":{"rendered":"<p>I&#8217;m trying to construct some formulas in Excel 2007 to sort some data and I&#8217;m just having trouble implementing a suitable sorting algorithm that gives me the result I want.<\/p>\n<p>My data looks a bit like this:<br \/>\n1.0 K<br \/>\n3.0 K<br \/>\n10.0 K<br \/>\n3.0 K, FWHM=0.4<br \/>\n1.5 K<\/p>\n<p>After sorting it needs to look like this:<br \/>\n1.0 K<br \/>\n1.5 K<br \/>\n3.0 K<br \/>\n3.0 K, FWHM=0.4 (if this is swapped with the one above it doesn&#8217;t matter)<br \/>\n10.0 K<\/p>\n<p>An alphabetical sort doesn&#8217;t work once I have numbers above 10. I&#8217;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&#8217;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.<\/p>\n<p>Any idea how I can accomplish this sort? I don&#8217;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.<\/p>\n<p>Thanks in advance for any help you can offer.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":18},"question-category":[53],"question_tags":[],"class_list":["post-15588","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/15588","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=15588"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=15588"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=15588"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=15588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}