←Back to all posts
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Sorting in a really weird way

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.

submitted by /u/Ok_Fondant1079
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article→

Tagged with

#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#Part numbers
#XNYY
#XNYYY
#XXNY
#XXNYY
#XXNYYY
#sorting
#format
#single number
#letters
#Xs
#Ys
#order
#Reddit
#submission
#comments