Posted to microsoft.public.excel.misc

tony

external usenet poster

Posts: 313

Sort by last two numbers

I would like to sort a group of numberic numbers (1234567) by the last two
numbers (i.e. 67) How do I do this?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 sort out all numbers without duplication?	Eric	Excel Discussion (Misc queries)	5	July 6th 07 03:58 PM
All numbers won't sort	Barb	Excel Discussion (Misc queries)	2	March 5th 07 10:00 PM
How to sort text as numbers	Kevin	Excel Discussion (Misc queries)	3	April 20th 06 10:27 PM
Sort numbers	JTH	Excel Discussion (Misc queries)	5	September 29th 05 12:47 AM
sort + & - numbers together	Rasoul Khoshravan Azar	Excel Worksheet Functions	1	December 18th 04 11:11 PM

All times are GMT +1. The time now is 02:04 AM.

About Us

"It's about Microsoft Excel"