Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Montreal, Quebec
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi gang,
    I have one sheet with Appointments that contains client name with appointment date.
    I have one sheet with client coordinates. I want to know the last date this client visited.
    tks.
    Johanne Champagne
    Montreal (Quebec) CANADA

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You can use an array formula for this (confirmed with Ctrl+Shift+Enter)

    {=MAX(IF($D$2:$D$100=G2,E2:$E$100))}

    Where $D$100 contains the names, G2 contains the name you are checking and $E$100 contains the dates of the visits

  3. #3
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Montreal, Quebec
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I must be doing something wrong.
    It gives me the last date on the list, not necessarily the last date for this person and in some cases I get nothing.
    I attached my spreadsheet.
    Tks
    Attached Files Attached Files
    Johanne Champagne
    Montreal (Quebec) CANADA

  4. #4
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You are not confirming the formula as an Array.
    Edit the formula in D2 (double click in the cell). Confirm the formula with Ctrl+Shift+Enter
    copy the formula down

  5. #5
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Montreal, Quebec
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yes. It works just fine now.
    Tks.
    Johanne Champagne
    Montreal (Quebec) CANADA

Posting Permissions

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