Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2004

Tip: Looking for answers? Try searching our database.

How do I sort for first/last date in a row?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cutter1966 - 29 Sep 2004 19:37 GMT
Sorry, but I am a noob with an urgent question

Lets say I have a list of 10 dates in a column
How do I show the earliest date in the 11th row?
How do I do it across 2 rows of data?

for example:
6/12
7/4
8/9
7/16
5/12
7/9

of this group: I should show 5/12 as the earliest date
8/9 as the latest date

but I want to sort without resorting the data in my column

Your soonest help would be greatly appreciated
Don Guillett - 29 Sep 2004 19:53 GMT
Have a look in HELP index for MAX and MIN

Signature

Don Guillett
SalesAid Software
donaldb@281.com

> Sorry, but I am a noob with an urgent question
>
[quoted text clipped - 16 lines]
>
> Your soonest help would be greatly appreciated
VENKAT - 01 Oct 2004 07:07 GMT
suppose your data is A1 to A10 in some other cell type
=min(a1:a10)
or
=max(a1:a10)

===================

> Sorry, but I am a noob with an urgent question
>
[quoted text clipped - 16 lines]
>
> Your soonest help would be greatly appreciated

Signature

Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.