excel-filter-trick-non-adjacent-columns

**pm_doctor** · 06-13-2023, 09:54 AM

Our Office 365 (and Excel) is using Dutch as language instead of English.
This means that we use a semicolon ( ; ) as a parameter delimiter in formulas instead of a colon ( , ).

Here is what I want to achieve :
See this topic "excel-filter-trick-non-adjacent-columns" at the XelPlus . com website (I am not allowed to post links)

I am trying to get this trick to work , but unfortunately it does not work because it refuses the colon between the accolades { } or curled brackets.

=FILTER(FILTER(TSal[[Name]:[Position]], Tsal[Salary] > J2), {1, 0, 0, 1})

Is there a solution for this kind of language problem in formulas ?? We need this semicolon because we use the colon for decimal notation of numbers.

**AliGW** · 06-13-2023, 09:57 AM

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Please add 365 to your profile Excel details. Thanks.

See this topic "excel-filter-trick-non-adjacent-columns" at the XelPlus . com website (I am not allowed to post links

No way, José!

Nobody should have to follow a link in order to be able to help you. Please explain everything in your post,

You could try this:

{1\0\0\1}

**pm_doctor** · 06-13-2023, 11:02 AM

Hi AliGW,

Thank you for your fast reply and suggestion.
The forward slash did not work, but the backslash solved the issue.

This is now my working solution --> =FILTER(FILTER(TBL_Data[[naam]:[taal]];TBL_Data[taal]="NL";"nothing here");{1\0\1})
By using a backslash instead of a colon, I can use this formula in my Dutch version of MS Office 365 for Enterprises (Version 2304)

**AliGW** · 06-13-2023, 11:15 AM

1. Please change yoyur forum profile to MS365 (2304).
2. Backslash was what I suggested!

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.