Forum Discussion
Help with complex string sorting in Excel
Hope someone can help me. So I have some data entries that come in at : 'Port 1 Magnitude Index:0' 'Port 1 Magnitude Index:1' 'Port 1 Magnitude Index:2' 'Port 1 Phase Index:0' 'Port 1 Phase Ind...
Create a custom list and sort by the custom list.
Reference: https://support.microsoft.com/en-us/office/create-or-delete-a-custom-list-for-sorting-and-filling-data-d1cf624f-2d2b-44fa-814b-ba213ec2fd61#:~:text=Follow%20these%20steps%3A%201%20In%20a%20range%20of,the%20list%20that%20you%20have%20...%20See%20More?msclkid=98c45259b1fc11ec9408acca81c19bda
Reference: https://support.microsoft.com/en-us/office/create-or-delete-a-custom-list-for-sorting-and-filling-data-d1cf624f-2d2b-44fa-814b-ba213ec2fd61#:~:text=Follow%20these%20steps%3A%201%20In%20a%20range%20of,the%20list%20that%20you%20have%20...%20See%20More?msclkid=98c45259b1fc11ec9408acca81c19bda