using Unique() function question

[INN]

Hi I have a table below and I want to answer this question
Q) List customers who have had service one time?
ps: this is not homework. I remember i was able to do that using Unique() question but I forgot how? Thank you so much

Customer Name	Service Type	Date
Mary	Tire Rotation	2023-04-03​
Eric	Oil Change	2023-06-11​
Jack	Brake Pads	2023-06-07​
Liz	Car Wash	2023-06-26​
Anna	Transmission Flush	2023-04-29​
liz	Tire Rotation	2023-03-28​
Sam	Oil Change	2023-05-01​
Jack	Brake Pads	2023-04-03​
Mary	Car Wash	2023-03-05​
Eric	Transmission Flush	2023-04-01​

 

[AhoyNC]

Maybe:

Book2
	A	B	C	D	E
1	Customer Name	Service Type	Date		1 Service
2	Mary	Tire Rotation	2023-04-03		Anna
3	Eric	Oil Change	2023-06-11		Sam
4	Jack	Brake Pads	2023-06-07
5	Liz	Car Wash	2023-06-26
6	Anna	Transmission Flush	2023-04-29
7	liz	Tire Rotation	2023-03-28
8	Sam	Oil Change	2023-05-01
9	Jack	Brake Pads	2023-04-03
10	Mary	Car Wash	2023-03-05
11	Eric	Transmission Flush	2023-04-01
Sheet1

Cell Formulas
Range	Formula
E2:E3	E2	=FILTER(A2:A11,COUNTIF($A$2:$A$11,$A$2:$A$11)=1)
Dynamic array formulas.

 

[Eric W]

Or just:

=UNIQUE(A2:A11,,1)

 

[INN]

Or just:

=UNIQUE(A2:A11,,1)

Thank you so much. I asked Chatgpt and they give me all kind of solution except this! Thank you again

 

[Eric W]

Thank you so much. I asked Chatgpt and they give me all kind of solution except this! Thank you again

That's why Chatgpt is not allowed on this forum - it's too unreliable so far.

Glad we could help!