HELP finding first Date of Clients

[Walker_Ice]

Hi Everyone,

I am trying to figure out how to find out when a client on my clientele list first visited our shop. Below is a sample table to give you an idea of what the clients list would look like and the date format that I am currently using.

TEsting_Excel_File.xlsx
	A	B	C	D	E	F	G	H	I
1	Client Name	Date	Payment					Unique Clients	Date of Arrived
2	Eminem	4-Feb-23	$1,200.00					Eminem	?
3	Jay Z	13-Mar-23	$1,450.00					Jay Z
4	Jay Z	17-Jun-23	$6,500.00					Paul Wall
5	Paul Wall	25-Apr-23	$2,345.00					Snoop Dog
6	Snoop Dog	17-Jun-23	$122.00					Mark Cuban
7	Mark Cuban	6-Jun-23	$1,234.00					Mr Wonderful
8	Mr Wonderful	20-Feb-23	$921.00					Kayla Smith
9	Eminem	28-Jun-23	$875.00					Cameron Smith
10	Kayla Smith	27-Jun-23	$901.00					Ted Cruz
11	Cameron Smith	17-Mar-23	$871.00					Tom Lee
12	Ted Cruz	7-Jun-23	$245.00
13	Snoop Dog	10-Jul-23	$6,543.00
14	Tom Lee	31-Mar-23	$234.00
15	Jay Z	1-Apr-23	$1,900.00
16
Sheet7

Cell Formulas
Range	Formula
H2:H11	H2	=UNIQUE(A2:A15)
Dynamic array formulas.

 

[KOKOSEK]

Date is a number so maybe You can use MINIFS?

=MINIFS($B:$B,$A:$A,$H2)

 

[kevin9999]

Book1
	A	B	C	D	E	F	G	H	I
1	Client Name	Date	Payment					Unique Clients	Date of Arrived
2	Eminem	04-Feb-23	$1,200.00					Eminem	04-Feb-23
3	Jay Z	13-Mar-23	$1,450.00					Jay Z	13-Mar-23
4	Jay Z	17-Jun-23	$6,500.00					Paul Wall	25-Apr-23
5	Paul Wall	25-Apr-23	$2,345.00					Snoop Dog	17-Jun-23
6	Snoop Dog	17-Jun-23	$122.00					Mark Cuban	06-Jun-23
7	Mark Cuban	06-Jun-23	$1,234.00					Mr Wonderful	20-Feb-23
8	Mr Wonderful	20-Feb-23	$921.00					Kayla Smith	27-Jun-23
9	Eminem	28-Jun-23	$875.00					Cameron Smith	17-Mar-23
10	Kayla Smith	27-Jun-23	$901.00					Ted Cruz	07-Jun-23
11	Cameron Smith	17-Mar-23	$871.00					Tom Lee	31-Mar-23
12	Ted Cruz	07-Jun-23	$245.00
13	Snoop Dog	10-Jul-23	$6,543.00
14	Tom Lee	31-Mar-23	$234.00
15	Jay Z	01-Apr-23	$1,900.00
Sheet1

Cell Formulas
Range	Formula
H2:H11	H2	=UNIQUE(A2:A15)
I2:I11	I2	=MINIFS(B:B,A:A,H2)
Dynamic array formulas.

 

[Walker_Ice]

Hello,

Thank you for your quick response. That did work, thank you for simplifying the function.

Below is the solution I used to solve this problem.

=IF(H2<>"", MIN(FILTER($B:$B, $A:$A = $H2)), "")

 

[CephasOz]

Or just add a # to @KOKOSEK's formula :

=MINIFS(B:B,A:A,H2#)

in cell I2.