Retrieving data from another sheet

[double0g]

Hi,

This is my list of data lets say on sheet 1. On Sheet 2 I want to see all the names, then the corresponding oldest date from sheet 1. (Im looking for the oldest item by person)

On Sheet 2 the column headings should be:

Name, Created, Last (modified), Next (modified), Item #

Book1
	A	B	C	D	E
1		Created	Last	Next	Number
2	fred	1/1/2004	1/5/2004	1/15/2004	1
3	Jim	1/5/2004	1/5/2004	1/12/2004	2
4	Bill	1/6/2004	1/14/2004	1/30/2004	3
5	tom	1/1/2004	1/18/2004	1/31/2004	4
6	paul	2/1/2004	2/5/2004	2/7/2004	5
7	fred	1/15/2004	1/17/2004	1/21/2004	6
8	Jim	1/16/2004	1/18/2004	1/22/2004	7
9	Bill	1/12/2004	1/12/2004	1/13/2004	8
10	tom	1/13/2004	1/14/2004	1/15/2004	9
11	paul	1/3/2004	1/5/2004	1/6/2004	10
12	tom	1/4/2004	1/12/2004	1/17/2004	11
13	tom	1/16/2004	1/17/2004	1/19/2004	12
14	paul	1/8/2004	1/13/2004	1/18/2004	13
15	fred	1/9/2004	1/12/2004	1/21/2004	14
Sheet1

 

[Aladin Akyurek]

How can this formula be altered so the names do not change order based on the oldest. As in, if I wanted the name list alphabetized then populated with the corresponding data for oldest create date?

You want the result area sorted on Name, right?

If so, did you take notice of my comment: "Note that the unique name list is not alphabetized. Although a different method is available for sorting this list, that method would cause futher slow down"?

 

[double0g]

It doesnt have to be alphabetized, but I was hoping to sort them by location based on the names. For instance let's say Tom & fred are in one location, Bill is in one location, etc.

My data source usually has about 1500, and its not giving me too much trouble when running it.

by the way...THANKS for your help!

 

[Aladin Akyurek]

by the way...THANKS for your help!

You're welcome.

It doesnt have to be alphabetized, but I was hoping to sort them by location based on the names. For instance let's say Tom & fred are in one location, Bill is in one location, etc.

My data source usually has about 1500, and its not giving me too much trouble when running it.

If I'm not mistaken the sample we used doesn't have location as field.

 

[double0g]

The original example didnt have a location field. It really doesnt need one, but would it be possible to reference the list of names pull the information?

Oldest create date for:

Tim
Bill

Frank etc.

 

[double0g]

If possible, I would like the results from sheet one to be displayed like this:

Book1
	A	B	C	D	E
1		Created	Last	Next	Number
2	Bill
3	Fred
4
5	Tom
6	Paul
7
8	Jim
Sheet2

(All cells with " " are blank when I copied the example)