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 #
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 |