it's an excel world
Board Regular
- Joined
- Sep 17, 2008
- Messages
- 126
Hello all,
I tried searching for this answer but couldn't find the exact question.
I have two columns of data
Column A are my order numbers that are repeated several time down the column. Column B are my order line dates. There may be several different dates corresponding to the same order number in column A, based on what date the line was added to the order.
I wanted to add a formula to column C that looks at the order number in column A, then identifies the earliest date in column B that has the same order number in column A. So when I copy this formula down the file, I will end up with one dater per order number (the earliest date).
Thanks in advance!
I tried searching for this answer but couldn't find the exact question.
I have two columns of data
Column A are my order numbers that are repeated several time down the column. Column B are my order line dates. There may be several different dates corresponding to the same order number in column A, based on what date the line was added to the order.
I wanted to add a formula to column C that looks at the order number in column A, then identifies the earliest date in column B that has the same order number in column A. So when I copy this formula down the file, I will end up with one dater per order number (the earliest date).
Thanks in advance!