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

Tonyd789

Board Regular
Joined
Feb 6, 2011
Messages
87
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!
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,342
=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.
 

Watch MrExcel Video

Forum statistics

Threads
1,100,138
Messages
5,472,742
Members
406,834
Latest member
RahafKh

This Week's Hot Topics

Top