Results 1 to 3 of 3

Thread: Return the value based on the another cells content within that row?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Feb 2011
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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!

  2. #2
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    8,153
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    2 Thread(s)

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

    =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.

  3. #3
    Board Regular
    Join Date
    Feb 2011
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    Thats great works like a charm thank you very much.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •