The filter function is not applied to all rows

%3CLINGO-SUB%20id%3D%22lingo-sub-1558145%22%20slang%3D%22en-US%22%3EThe%20filter%20function%20is%20not%20applied%20to%20all%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1558145%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20could%20find%20previous%20posts%20with%20this%20problem%2C%20but%20the%20filter%20function%20is%20not%20being%20applied%20to%20all%20rows%20of%20a%20sheet.%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20formatted%20as%20a%20table%20which%20include%20the%20%22un-filterable%22%20rows%2C%20but%20that%20doesn't%20do%20the%20trick.%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20helping%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1558145%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1558290%22%20slang%3D%22en-US%22%3ERe%3A%20The%20filter%20function%20is%20not%20applied%20to%20all%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1558290%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F745785%22%20target%3D%22_blank%22%3E%40DanielFernandez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20post%2C%20if%20not%20the%20actual%20spreadsheet%2C%20a%20copy%20of%20the%20FILTER%20function%20you've%20written%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESeveral%20possibilities%20occur%20to%20me.%20In%20general%2C%20although%20we%20may%20be%20tempted%20to%20say%20%22Excel%20is%20not%20working%22%2C%20or%2C%20as%20you%20have%20here%2C%20%22the%20FILTER%20function%20is%20not%20working%2C%22%20it's%20far%20more%20likely%20that%20we%2C%20the%20user%2C%20have%20done%20(or%20not%20done)%20something%20that%20causes%20the%20appearance%20of%20failure%20in%20question.%20In%20other%20words%2C%20it's%20far%20more%20likely%20that%20the%20FILTER%20function%20is%20working%20as%20it%20should%20than%20that%20it%20(after%20working%20in%20thousands%2C%20if%20not%20millions%2C%20of%20other%20spreadsheets%20around%20the%20globe)%20has%20chosen%20you%20and%20your%20application%20to%20suddenly%20apply%20itself%20to%20only%20a%20subset%20of%20the%20rows.....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20describe%20or%20discern%20something%20distinctive%20about%20the%20rows%20to%20which%20it%20IS%20being%20applied%2C%20in%20contrast%20with%20those%20that%20it's%20not%3F%20Is%20it%20only%20picking%20up%20rows%20at%20the%20top%2C%20not%20the%20bottom%20of%20the%20full%20range%3F%20Or%20vice%20versa%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20possible%2C%20for%20example%2C%20that%20there%20is%20not%20be%20a%20match%20between%20how%20you%20specified%20the%20rows%20to%20be%20filtered%20and%20rows%20of%20the%20column(s)%20to%20be%20used%20as%20criteria%20for%20the%20filtering%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20write%20that%20your%20data%20are%20%22%3CU%3E%3CSTRONG%3Eformatted%3C%2FSTRONG%3E%3C%2FU%3E%20as%20a%20table%22%20and%20that%20could%20mean%20%22I%20made%20it%20look%20like%20a%20table%22%20as%20opposed%20to%20%22I%20set%20it%20up%20as%20an%20official%20Table%3B%20it%20has%20a%20name.%20In%20the%20FILTER%20function%20I%20see%20the%20table's%20name%20and%20the%20column's%20names%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%2C%20those%20are%20two%20things%20to%20look%20at.......%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1558458%22%20slang%3D%22de-DE%22%3ESubject%3A%20The%20filter%20function%20is%20not%20applied%20to%20all%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1558458%22%20slang%3D%22de-DE%22%3EIf%20you%20could%20send%20a%20worksheet%20with%20the%20problem%20(without%20sensitive%20data)%2C%20it%20would%20be%20an%20advantage%20...%20for%20you%20and%20for%20all%20who%20would%20like%20to%20help%20solve%20your%20problem.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20thank%20you%20%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1640916%22%20slang%3D%22en-US%22%3ERe%3A%20The%20filter%20function%20is%20not%20applied%20to%20all%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1640916%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20time.%3C%2FP%3E%3CP%3EI%20have%20revised%20the%20filter%20function%20again%2C%20and%20you%20indicated%20it%20was%20a%20user%20mistake%2C%20where%20the%20table%20%22range%22%20was%20inadequately%20defined.%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1640917%22%20slang%3D%22en-US%22%3EBetreff%3A%20The%20filter%20function%20is%20not%20applied%20to%20all%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1640917%22%20slang%3D%22en-US%22%3EThanks%20for%20your%20interest.%3CBR%20%2F%3EI%20had%20incorrectly%20defined%20the%20range%20of%20the%20table%20in%20the%20formula....%3C%2FLINGO-BODY%3E
New Contributor

Hi, 

I could find previous posts with this problem, but the filter function is not being applied to all rows of a sheet. 

It is formatted as a table which include the "un-filterable" rows, but that doesn't do the trick.

Thanks in advance for helping

Cheers

4 Replies

@DanielFernandez 

 

Can you post, if not the actual spreadsheet, a copy of the FILTER function you've written?

 

Several possibilities occur to me. In general, although we may be tempted to say "Excel is not working", or, as you have here, "the FILTER function is not working," it's far more likely that we, the user, have done (or not done) something that causes the appearance of failure in question. In other words, it's far more likely that the FILTER function is working as it should than that it (after working in thousands, if not millions, of other spreadsheets around the globe) has chosen you and your application to suddenly apply itself to only a subset of the rows.....

 

Can you describe or discern something distinctive about the rows to which it IS being applied, in contrast with those that it's not? Is it only picking up rows at the top, not the bottom of the full range? Or vice versa?

 

It's possible, for example, that there is not be a match between how you specified the rows to be filtered and rows of the column(s) to be used as criteria for the filtering

 

You write that your data are "formatted as a table" and that could mean "I made it look like a table" as opposed to "I set it up as an official Table; it has a name. In the FILTER function I see the table's name and the column's names"

 

Anyway, those are two things to look at....... 

If you could send a worksheet with the problem (without sensitive data), it would be an advantage ... for you and for all who would like to help solve your problem.

thank you
Nikolino
I know I don't know anything (Socrates)

Hello @mathetes 

 

Thanks for your time.

I have revised the filter function again, and you indicated it was a user mistake, where the table "range" was inadequately defined.

Cheers

Thanks for your interest.
I had incorrectly defined the range of the table in the formula....