•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Sorting in a really weird way
Our take
Sorting part numbers can be a complex task, especially when they follow unique formats like XNYY, XNYYY, XXNY, XXNYY, and XXNYYY. In this scenario, each part number features a single digit nestled between two sets of letters. To achieve a meaningful sort, the goal is to organize these entries based on the letters that follow the number. This approach not only simplifies data management but also enhances clarity, making it easier to locate and analyze specific parts. Join the discussion to explore innovative sorting techniques.
Part numbers are of the form;
XNYY
XNYYY
XXNY
XXNYY
XXNYYY
So, there is always a single number between the Xs and the Ys. I want to sort according to the letters after the single number.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience