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

Sign in

(thinking…)

Sign in with:

Facebook

Google

Forgot password?

Create a password

Signed in as (Sign out)

We’ll send you updates on this idea

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

3 comments

Add a comment…

Sign in

(thinking…)

Sign in with:

Facebook

Google

Forgot password?

Create a password

Signed in as (Sign out)

Submitting...

An error occurred while saving the comment

PT commented · December 3, 2019 11:21 AM · Flag as inappropriate

Must have please.

Submitting...
Sam Thompson commented · April 17, 2018 2:00 PM · 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 4:58 AM · Flag as inappropriate

a frequent need

Submitting...

Sign in

(thinking…)

Sign in with:

Facebook

Google

Forgot password?

Create a password

Signed in as (Sign out)

Sign in
Sign up

Excel for Windows (Desktop Application): Data Import

Post a new idea…
All ideas
My feedback
Charting, Mapping and Visualizations 502
Collaboration and Sharing 190
Data Import 536
Editing 731
Formatting 968
Formulas and Functions 1193
Graphics 152
Macros and Add-ins 363
Opening and Saving Files 405
Other 1198
Performance 248
PivotTables and Power Pivot 337
Printing 128
Product Setup and Activation 48
Surveys 10
Tables, Sorting and Filtering 377
Viewing / Navigating Workbooks 576

Searching…

No results.
Clear search results

Give feedback
- Excel for Mac 1,748 ideas
- Excel for Mobile Devices, Tablets, Phones (Android, iOS, Windows Mobile) 1,333 ideas
- Excel for the web 2,874 ideas
- Excel for Windows (Desktop Application) 8,272 ideas
Office.com