Morning all,
I have used an array formula previously to search for oldest date however cant adapt this to work on what I have on another sheet.
Basically I have two columns lets say A and B
In column A I have loads of project names, there will be repeats here. In column B I have dates.
eg
COLUMN A ............COLUMN B
Making toast ............01/01/13
Making toast ............02/01/13
Making bread ..............01/21/13
Making eggs ............03/01/13
Making eggs ..............08/03/13
Making toast............. 01/01/13
Making toast ..............01/02/13
Making toast .............09/03/13
Making toast ...............01/01/13
basically i want a thing where it looks up "making toast" and tells me the earliest date in column b
thanks
I have used an array formula previously to search for oldest date however cant adapt this to work on what I have on another sheet.
Basically I have two columns lets say A and B
In column A I have loads of project names, there will be repeats here. In column B I have dates.
eg
COLUMN A ............COLUMN B
Making toast ............01/01/13
Making toast ............02/01/13
Making bread ..............01/21/13
Making eggs ............03/01/13
Making eggs ..............08/03/13
Making toast............. 01/01/13
Making toast ..............01/02/13
Making toast .............09/03/13
Making toast ...............01/01/13
basically i want a thing where it looks up "making toast" and tells me the earliest date in column b
thanks