Posted to microsoft.public.excel.misc

Liliana[_4_] Liliana[_4_] is offline

external usenet poster

Posts: 39

Sort by number only in cell

Microsoft has a ready-rolled array formula:

http://office.microsoft.com/en-gb/ex...549011033.aspx

Don't forget Ctrl-Shift-Enter

?B?c2VyZW5kaXBpdHkyNTg=?=
wrote in :

3
A100C
A100D
AB205
B4
53DE

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Number sort in Excel	AnitaG	Excel Discussion (Misc queries)	3	February 6th 09 04:35 PM
Sort by part of a number	sacredarms	New Users to Excel	2	July 25th 06 06:48 PM
Sort by number not by letter (C1, A2, B3, D4)	dukemeiser	Excel Discussion (Misc queries)	3	May 5th 06 02:40 AM
sort by section number	alslm	Excel Discussion (Misc queries)	1	April 14th 05 04:55 PM
Excel Sort function should not sort the cell formatting!	Lisa D.N.1	Excel Worksheet Functions	1	December 28th 04 08:37 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us