I am looking for a formula that will look at the value in the WeekA column and bring back the min SD and the max FD. The Min Start column is the value I should get for all cells in WeekA with 17.
SD FD WeekA Min Start Max Finished
03/31/03 04/22/03 17 3/31/2003 4/23/2003
04/02/02 04/23/03 17 3/31/2003 4/23/2003
10/15/02 11/15/02 46
10/16/02 11/14/02 46
Any help would be greatly appreciated. Thanks
SD FD WeekA Min Start Max Finished
03/31/03 04/22/03 17 3/31/2003 4/23/2003
04/02/02 04/23/03 17 3/31/2003 4/23/2003
10/15/02 11/15/02 46
10/16/02 11/14/02 46
Any help would be greatly appreciated. Thanks