Results 1 to 2 of 2

Conditional First and Last Dates

Threaded View

Marlow Conditional First and Last... 05-09-2012, 05:49 PM
FDibbins Re: Conditional First and... 05-09-2012, 06:04 PM
  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    1

    Conditional First and Last Dates

    I have a worksheet containing contact dates for a list of supporters. I am trying to, in a separate worksheet, list the first and last dates that each supporter was contacted. So the source worksheet looks something like this:

    id name date
    11 Bob Smith 1/1/2007
    11 Bob Smith 2/1/2007
    12 Jane Jones 3/1/2007
    12 Jane Jones 4/1/2007
    12 Jane Jones 5/1/2007

    And the destination worksheet has the following column headings

    id name first date last date

    I feel that I should be able to somehow conditionally use the id fields to fill in the first and last dates, but can't seem to get the formula right. I realize that the formula is complicated by the fact that the source data and the destination cells are on two different worksheets, but that is the way it has to be.

    Any help would be greatly appreciated.
    Last edited by Marlow; 05-09-2012 at 06:09 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1