Column A contains different commercial titles (Nike 1, Nike 2, Nike 3, etc.). Column B contains a single date that the commercial aired on. For example:
A B
Nike 1 01/02/02
Nike 1 03/01/02
Nike 1 02/26/02
Nike 2 12/31/01
Nike 2 5/14/01
Nike 3 6/12/01
Nike 3 12/13/01
Nike 3 11/4/01
How can I create a formula that will return a first air date and last air date for each commercial? I need the formula to look at all the dates in column B for each different commercial and return the earliest air date and the most recent air date.
In the above example, the formula would return for "Nike 1" First Air Date - 1/2/02, Last Air Date - 3/1/02
I could sort by A then by B and manually look up the first and last air dates but that would take too long considering there are thousands of dates to scroll through for each commercial.
This message was edited by Harley on 2002-04-05 09:10
This message was edited by Harley on 2002-04-05 09:11
This message was edited by Harley on 2002-04-05 09:11
A B
Nike 1 01/02/02
Nike 1 03/01/02
Nike 1 02/26/02
Nike 2 12/31/01
Nike 2 5/14/01
Nike 3 6/12/01
Nike 3 12/13/01
Nike 3 11/4/01
How can I create a formula that will return a first air date and last air date for each commercial? I need the formula to look at all the dates in column B for each different commercial and return the earliest air date and the most recent air date.
In the above example, the formula would return for "Nike 1" First Air Date - 1/2/02, Last Air Date - 3/1/02
I could sort by A then by B and manually look up the first and last air dates but that would take too long considering there are thousands of dates to scroll through for each commercial.
This message was edited by Harley on 2002-04-05 09:10
This message was edited by Harley on 2002-04-05 09:11
This message was edited by Harley on 2002-04-05 09:11