Concat Values and Include Value if Greater Than 1

[jessebh2003]

In my table, I'm trying to combine values using concat but I only want the third item included if the value is greater than one. I've tried this a couple ways (columns Full Name and Full Name2) but neither is giving me the value I'm looking for.

Here's what I'm trying to achieve:

1. Is the value in Duplicate Value > 1
2. If TRUE, concat First Name, " ", Last Name, " ", Duplicate Value
3. If FALSE, concat First Name, " ", Last Name

However,

=CONCAT([@[First Name]]," ",[@[Last Name]]," ",[@[Duplicate Value]])

returns First Name, " ", Last Name, " ", Duplicate Value and

=IF(COUNTA([@[Duplicate Value]])>1,CONCAT([@[First Name]]," ",[@[Last Name]]," ",[@[Duplicate Value]]),CONCAT([@[First Name]]," ",[@[Last Name]]))

returns First Name, " ", Last Name.

Appreciate any help in getting this to work right! Thanks.

NPO Credit & Video Tracking Combined Report.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Activity ID	Start Date	Description	ID	Name	First Name	Last Name	Full Name	Duplicate Value	Full Name2
2	12345	08/24/2021	Event Name One	67890	Jane Doe, MBA	Jane	Doe	Jane Doe 1	1	Jane Doe
3	12345	07/27/2021	Event Name Two	67890	Jane Doe, MBA	Jane	Doe	Jane Doe 2	2	Jane Doe
Sheet2

Cell Formulas
Range	Formula
H2:H3	H2	=CONCAT([@[First Name]]," ",[@[Last Name]]," ",[@[Duplicate Value]])
I2:I3	I2	=COUNTIF($E$2:$E2,$E2)
J2:J3	J2	=IF(COUNTA([@[Duplicate Value]])>1,CONCAT([@[First Name]]," ",[@[Last Name]]," ",[@[Duplicate Value]]),CONCAT([@[First Name]]," ",[@[Last Name]]))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I2:I3	Cell Value	=1	text	NO

 

[Fluff]

How about

=TEXTJOIN(" ",,[@[First Name]],[@[Last Name]],IF([@[Duplicate Value]]>1,[@[Duplicate Value]],""))

 

[etaf]

does
=IF(I2>1,F2&" "&G2&" "&I2,F2&" "&G2)
work ?

 

[jessebh2003]

Amazing, Fluff! Worked perfectly. Thank you!!

 

[Fluff]

Glad we could help & thanks for the feedback.