Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

← Excel for Windows (Desktop Application)

full anti join (Power Query)

Do a Right and Left Anti Join in one sweep. So figure out the outliers in both tables in one go.

17 votes

Gašper Kamenšek shared this idea · March 24, 2018 · Flag idea as inappropriate… · Admin →

4 comments

An error occurred while saving the comment

David commented · March 17, 2021 13:09 · Flag as inappropriate

I have a regular need for this. Seems silly to leave out as a join type.

Submitting...
PT commented · December 03, 2019 11:21 · Flag as inappropriate

Must have please.

Submitting...
Sam Thompson commented · April 17, 2018 14:00 · Flag as inappropriate

Yeah this is a biggy. Understand we can do it with a left and a right anti join but this is two steps too many.

Submitting...
Anonymous commented · March 27, 2018 04:58 · Flag as inappropriate

a frequent need

Submitting...

Excel for Windows (Desktop Application): Data Import

Post a new idea…
All ideas
My feedback
Charting, Mapping and Visualizations 512
Collaboration and Sharing 194
Data Import 584
Editing 771
Formatting 1018
Formulas and Functions 1270
Graphics 160
Macros and Add-ins 374
Opening and Saving Files 427
Other 1365
Performance 262
PivotTables and Power Pivot 354
Printing 134
Product Setup and Activation 49
Surveys 10
Tables, Sorting and Filtering 406
Viewing / Navigating Workbooks 608

Searching…

No results.
Clear search results

Give feedback
- Excel for Mac 1,851 ideas
- Excel for Mobile Devices, Tablets, Phones (Android, iOS, Windows Mobile) 1,385 ideas
- Excel for the web 2,908 ideas
- Excel for Windows (Desktop Application) 8,808 ideas
Office.com