No Join Kind dropdown in Merge dialog

xlWatcher

New Member
Joined
Feb 20, 2020
Messages
6
Office Version
2016
Platform
Windows
I somehow managed to update my Office 2016, and then I tried this task again, in order to share and upload for you.....and there it was. Join Kind and I clicked on the full join which is what was needed! It really wan't there before the update...as you saw in the screenshot!
Thank you for your time and help
I usually use Excel to set up simple workbooks and formulas for small businesses, some graphing a little dashboarding. I'm a little new to data management in Excel, so I'll be back, I'm sure. :)
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,464
Office Version
365
Platform
Windows
For the future, please note that cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!


Cross posted at: Selecting Join Kind

If you do cross-post in the future and also provide a link, then there shouldn’t be a problem.
 

Watch MrExcel Video

Forum statistics

Threads
1,096,292
Messages
5,449,496
Members
405,569
Latest member
deanro

This Week's Hot Topics

Top