Hi, need some help. Below is an example of my data which comes from a very large database. Column B is a date that can be when the client renewed their terms with us (if the client is listed more than once) or originally signed with us (if listed just once). I want to put a formula in column C that will flag which row is the earliest date on file with that client. It's probably a simple IF(AND(MIN type of function, but it's not coming to me... Any suggestions?
If my data was nicely organized as shown below it would be easy to just flag the first mention of the client ID #. But it isn't.
A B
1 Client Date
2 111 01/1/2016
3 111 01/1/2017
4 111 01/1/2018
5 122 01/1/2016
6 122 02/23/2017
7 122 06/1/2017
8 444 5/1/2017
9 445 9/1/2018
10 446 10/1/2015
11 446 01/1/2016
12 446 08/1/2016
13 446 01/1/2017
14 446 10/1/2018
If my data was nicely organized as shown below it would be easy to just flag the first mention of the client ID #. But it isn't.
A B
1 Client Date
2 111 01/1/2016
3 111 01/1/2017
4 111 01/1/2018
5 122 01/1/2016
6 122 02/23/2017
7 122 06/1/2017
8 444 5/1/2017
9 445 9/1/2018
10 446 10/1/2015
11 446 01/1/2016
12 446 08/1/2016
13 446 01/1/2017
14 446 10/1/2018