Return the value based on the another cells content within that row?

[Tonyd789]

Hi All

I'm finding a solution to this problem of mine some what tricky! Hopefully someone a lot smarter than me will have an answer.

I have a spreadsheet that records accidents for multiple sites, 1 row = a new accident

Along the row it has a date of the accident in column B, further along in column N it has the site, I'm only interested in 1 particular site, "Pioneer Point".

So i need a formula to return the last accident date, but only if the site is Pioneer point.

I'm trying to have a # days since last accident, but only for this site.

Many thanks for your time and help!

 

[Special-K99]

=MAX(IF(N1:N1000="Pioneer Point",B1:B1000)
Array formula, use Ctrl-Shift-Enter

Array formulas are slow, it is not advisable to have too many of them in a spreadsheet.

 

[Tonyd789]

Thats great works like a charm thank you very much.