Merge Cells in one cell

Matinmusleh

New Member
Joined
Aug 15, 2024
Messages
11
Office Version
  1. 365
Platform
  1. Windows
Hello,
Need Help on my task,
I need to merge the OEM number in the attached without losing the TYPID.
 

Attachments

  • Screenshot 2024-08-15 100959.png
    Screenshot 2024-08-15 100959.png
    94.5 KB · Views: 20

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
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 ;))
 
Upvote 0
You are using 2019 & not 365, so I would suggest that you update you profile to show that.
 
Upvote 0
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 :)
 

Attachments

  • Screenshot 2024-08-15 145550.png
    Screenshot 2024-08-15 145550.png
    117.2 KB · Views: 4
Upvote 0
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.
 
Upvote 0
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.
1723723610445.png
 
Upvote 0

Forum statistics

Threads
1,226,693
Messages
6,192,471
Members
453,726
Latest member
JoeH57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top