Thread: [Solved] Data Sorting Question
View Single Post
 
Old 02-02-2015, 07:49 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Sure. Rather than one column, use two. The first can be you letter designation. You can derive this automatically using a text function e.g. =left(A1,1). The next can be your serial designation e.g. 1,2,3,...99. Then sort using those two columns.
Reply With Quote