Flag first date in a series from a database

[NewUser2]

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

 

[Legacy 436357]

Hello,

I added oldest and newest in this example using MIN and MAX:

Excel Workbook
	A	B	C	D	E
1	Client	Date		Client	111
2	111	1/1/2016		Oldest Date	1/1/2016
3	111	1/1/2017		Newest Date	1/1/2018
4	111	1/1/2018
5	122	1/1/2016
6	122	2/23/2017
7	122	6/1/2017
8	444	5/1/2017
9	445	9/1/2018
10	446	10/1/2015
11	446	1/1/2016
12	446	8/1/2016
13	446	1/1/2017
14	446	10/1/2018
Sheet1

 

[NewUser2]

Perfect, thanks!

Hello,

I added oldest and newest in this example using MIN and MAX:

Sheet1

	A	B	C	D	E
	Client
	Oldest Date
	Newest Date

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:85.6px;"><col style="width:85.6px;"><col style="width:28px;"><col style="width:105.6px;"><col style="width:85.6px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="align: center"]Client[/TD]
[TD="align: center"]Date[/TD]

[TD="align: center"]111[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="align: center"]111[/TD]
[TD="align: center"]1/1/2016[/TD]

[TD="align: center"]1/1/2016[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="align: center"]111[/TD]
[TD="align: center"]1/1/2017[/TD]

[TD="align: center"]1/1/2018[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="align: center"]111[/TD]
[TD="align: center"]1/1/2018[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]
[TD="align: center"]122[/TD]
[TD="align: center"]1/1/2016[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]
[TD="align: center"]122[/TD]
[TD="align: center"]2/23/2017[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]
[TD="align: center"]122[/TD]
[TD="align: center"]6/1/2017[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]
[TD="align: center"]444[/TD]
[TD="align: center"]5/1/2017[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]
[TD="align: center"]445[/TD]
[TD="align: center"]9/1/2018[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]
[TD="align: center"]446[/TD]
[TD="align: center"]10/1/2015[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]11[/TD]
[TD="align: center"]446[/TD]
[TD="align: center"]1/1/2016[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]12[/TD]
[TD="align: center"]446[/TD]
[TD="align: center"]8/1/2016[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]13[/TD]
[TD="align: center"]446[/TD]
[TD="align: center"]1/1/2017[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]14[/TD]
[TD="align: center"]446[/TD]
[TD="align: center"]10/1/2018[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula E2 {=MIN(IF(A2:A14=E1,B2:B14))} E3 {=MAX(IF(A2:A14=E1,B2:B14))} <tbody> </tbody>

Formula Array: Produce enclosing { } by entering formula with CTRL+SHIFT+ENTER!

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[Legacy 436357]

Very welcome!