Posted to microsoft.public.excel.programming

Dave B[_3_] Dave B[_3_] is offline

external usenet poster

Posts: 25

ordering

Hey gurus,

I have a list of dates in cells A1:A6

06/30/2002
06/30/2002
06/30/2005
06/30/2005
06/30/2000
06/30/2003

In cell B1 on the next worksheet, I have =MIN(Sheet1!A1:A6), which in this
case equals 06/30/2000. I want to use a single formula in the cells below
B1 to order the rest of the dates so that cells B1:B4 on the second sheet
will display, in order

06/30/2000
06/30/2002
06/30/2003
06/30/2005

Can this be done with a single formula? Thanks.

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
Build too for ordering	luckytr	New Users to Excel	2	December 11th 08 06:14 PM
Ordering Problem	JD	Excel Discussion (Misc queries)	4	January 24th 08 09:26 PM
ordering	pytelium	Excel Discussion (Misc queries)	3	March 13th 06 11:21 PM
Need help on formulating ordering	Angela	Excel Worksheet Functions	2	October 7th 05 08:38 PM
Ordering Patterns	Tom Hewitt	Excel Discussion (Misc queries)	0	September 20th 05 03:06 PM

All times are GMT +1. The time now is 05:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us