Merge Cells in one cell

[Matinmusleh]

Hello,
Need Help on my task,
I need to merge the OEM number in the attached without losing the TYPID.

 

[Fluff]

but the Meassge " The Function Isnt Valid

That sounds as though you are using Xl 2019 or earlier, failing that you have 365 but it has not been updated since Jan 2020.

 

[Fluff]

ignore_empty parameter in TEXTJOIN is required.

No it isn't. I always leave it empty unless I don't want to ignore blanks & then I use 0 rather than FALSE (it's less typing )

 

[Matinmusleh]

It is hard to tell what is the problem: a) do you really have Excel 365? b) What language version of Excel are you using?

 

[Matinmusleh]

It is hard to tell what is the problem: a) do you really have Excel 365? b) What language version of Excel are you using?

 

[RajeshKumar1313]

Hello, Thnks ,
but the Meassge " The Function Isnt Valid

here is for 2019 version
=TEXTJOIN(",",,IF($G2=$B$2:$B$18,IF($H2=$C$2:$C$18,($D$2:$D$18),""),""))

 

[Fluff]

You are using 2019 & not 365, so I would suggest that you update you profile to show that.

 

[Matinmusleh]

here is for 2019 version
=TEXTJOIN(",",,IF($G2=$B$2:$B$18,IF($H2=$C$2:$C$18,($D$2:$D$18),""),""))

HeLLO Friend , Not working
here is the actual file to be apply in , can you advise or any body

 

[Fluff]

You will need to confirm the formula with Ctrl Shift Enter, rather than just Enter.

Also please update your profile to show 2019 rather than 365.

 

[myall_blues]

No it isn't. I always leave it empty unless I don't want to ignore blanks & then I use 0 rather than FALSE (it's less typing )

Then MS documentation is wrong, which probably shouldn’t surprise me.

 

[Fluff]

Yup, that info is indeed wrong.