LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 30
Default Sorting a six digit number by terminal digit

Howdy All,

I have record information in a spreadsheet that contains terminal digit
record numbers.

Terminal digit is a filing system that uses 3 sets of 2 numbers, example 12
34 56. But the system works kind of in reverse, 56 is the first number you
look at, then 34, then 12.

I have these record numbers in column B. I need to sort them by terminal
digit, meaning by the last 2 numbers first, then by the middle 2, and lastly
by the first 2.


Can someone help me out with a simple solution?

Thanks,
Brian


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to input a 12 digit number into a cell jedi New Users to Excel 11 June 19th 06 08:26 PM
How do i save a 12 digit number in a .csv document in excell? darin van houten Excel Discussion (Misc queries) 2 March 27th 06 11:31 PM
Display a 16 digit number GrlsWthCrls Excel Discussion (Misc queries) 2 January 6th 06 07:10 PM
Letters and 000s in front of actual number not sorting correctly darkjedi Excel Discussion (Misc queries) 1 December 1st 05 03:48 PM
When we enter a 16 digit number (credit card) the last digit chan. ceking Excel Discussion (Misc queries) 5 December 8th 04 11:45 PM


All times are GMT +1. The time now is 02:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"