I have multiple "Tickers", but with different dates. I want to find the oldest date, based upon each ticker (Column C is the end result I am looking to get).
Note that sometimes, there is only one Ticker, while other times, there are 2, 3, or more. I cannot figure out what to do.
Office Excel 2016 (Windows) 32 bit
Excel 2016 (Windows) 32 bit
Note that sometimes, there is only one Ticker, while other times, there are 2, 3, or more. I cannot figure out what to do.
Office Excel 2016 (Windows) 32 bit
Excel 2016 (Windows) 32 bit
A | B | C | |
---|---|---|---|
1 | TICKER | DATE | Desired Result |
2 | AA | 04/18/2018 | 04/18/2018 |
3 | AAC | 08/02/2017 | 08/02/2017 |
4 | AAC | 11/01/2017 | 08/02/2017 |
5 | AAC | 02/21/2018 | 08/02/2017 |
6 | AAC | 05/02/2018 | 08/02/2017 |
7 | AAL | 01/25/2018 | 01/25/2018 |
8 | AAL | 07/26/2018 | 01/25/2018 |
Sheet: TEMP |
Last edited: