First and Last instance of a Value

Good afternoon,

I think this will be a fairly basic formula, but my mind is not on it today.

On the attached sheet, I just need to find the first date and the last date that a value from Column C appears in column B. I would like the results in columns E and F.


Some of the Values may not appear at all, which is expected.

Thanks in advance

Darren

Hi Grimace,

This is actually quite difficult (for someone at my skill level anyway) as it involves left lookups and date matching.

That said, have a look at the attached where I used an old formula I had for Column E and adapted Krishnakumar post from here for Column F.

HTH

Robert