|
|
#4
02-02-2015, 07:49 AM
|
|||
|
|||
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.
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need help sorting data in columns that will sort by number of Xs | brenna.at.work | Excel | 8 | 04-12-2014 07:00 AM |
| Question about sorting paragraphs in Word 2007 | WaltR | Word | 5 | 02-21-2014 09:16 PM |
| Sorting blocks of data | GenPerson | Excel | 0 | 11-29-2012 02:46 AM |
| Can I do this? sorting data in seperate columns | shumonsaha | Excel | 0 | 07-04-2010 03:05 AM |
 Sorting question
|
markg2 | Excel | 4 | 01-25-2010 03:13 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode