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.

 

[RajeshKumar1313]

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

=TEXTJOIN(",",,IF([@PRODUCT]=[PRODUCT],IF([@TYPID]=[TYPID],([OEM]),""),""))

 

[Matinmusleh]

=TEXTJOIN(",",,IF([@PRODUCT]=[PRODUCT],IF([@TYPID]=[TYPID],([OEM]),""),""))

Hello Rajesh
out come on my sheet is joining all OEM's together check the

 

[RajeshKumar1313]

Hello Rajesh
out come on my sheet is joining all OEM's together check the

show me your applied formula

 

[Matinmusleh]

show me your applied formula

here u go

 

[Fluff]

See post#18.

 

[Matinmusleh]

See post#18.

worked Thank you

 

[Matinmusleh]

THANK YOU EVERY1 ALOT , U ALL AMAZING PEOPLE ,,,,

 

[Fluff]

Please remember to change your profile to 2019, it saves members from suggesting something that won't work for you.