HELP finding first Date of Clients

KOKOSEK

Well-known Member

Joined

Apr 8, 2019

Messages

569

Office Version

1. 365
2. 2013

Platform

1. Windows

• Feb 3, 2024

• #2

Date is a number so maybe You can use MINIFS?

Excel Formula:

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

 

Upvote 0

Solution

K

kevin9999

Well-known Member

Joined

Aug 28, 2020

Messages

3,726

Office Version

1. 365

Platform

1. Windows

• Feb 3, 2024

• #3

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.

 

Upvote 0

W

Walker_Ice

Board Regular

Joined

Oct 6, 2023

Messages

50

Office Version

1. 2021

Platform

1. MacOS

• Feb 3, 2024

• #4

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)), "")

 

Upvote 0

CephasOz

Active Member

Joined

Feb 18, 2020

Messages

283

Office Version

1. 365

Platform

1. Windows

• Feb 3, 2024

• #5

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

Excel Formula:

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

in cell I2.

 

Upvote 0