vLookUp Min value

[buffyslay]

ok - braindead from Xmas...

but....

i have a spreadsheet with lots of people in. I want to be able pull
out the earliest start and end date... and the latest start and end
date


name start end
bob 1/1 1/2
bob 2/2 1/3
bob 2/5 1/6
dave 1/2 3/2


so what i want is
bob first start date 1/1
bob first end date 1/2

bob last start date 2/5
bob last end date 1/6


any ideas?

thanks

 

[Don Guillett]

Make sure your dates are formatted as dates and then
=min(h2:h6) or max(i2:i6)

 

[Buffyslay_co_uk]

Make sure your dates are formatted as dates and then
=min(h2:h6) or max(i2:i6)

sorry that would be right - but there are other people in the list and
i would need for each person = i have kind of sorted using an array
=MAX(IF(Contracts!$E$1:$E$100=D8,Contracts!$T$1:$T$100))
but it seems very messy.

Sorry i should have said more in the first post