function filtre

%3CLINGO-SUB%20id%3D%22lingo-sub-3459981%22%20slang%3D%22en-US%22%3Efunction%20filtre%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3459981%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20guys%20please%20i%20have%20a%20question%26nbsp%3B%3CBR%20%2F%3Ewhy%20when%20i%20try%20filtre%20function%20in%20the%20same%20sheet%20of%20table%20used%20in%20the%20function%20it%20works%20well%20but%20when%20i%20write%20it%20in%20other%20sheet%20it%20doesn't%20work.%3CBR%20%2F%3Ewhat%20is%20the%20solution%20please%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22safwen_0-1654174432900.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22safwen_0-1654174432900.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22safwen_0-1654174432900.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22safwen_0-1654174432900.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22safwen_0-1654174432900.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22safwen_0-1654174432900.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22safwen_0-1654174432900.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F377156iF5FA5D55BA90CEFF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22safwen_0-1654174432900.png%22%20alt%3D%22safwen_0-1654174432900.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22safwen_1-1654174446776.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22safwen_1-1654174446776.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22safwen_1-1654174446776.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22safwen_1-1654174446776.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22safwen_1-1654174446776.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22safwen_1-1654174446776.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22safwen_1-1654174446776.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F377157iB1BE5997B5BD1610%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22safwen_1-1654174446776.png%22%20alt%3D%22safwen_1-1654174446776.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3459981%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3460048%22%20slang%3D%22en-US%22%3ERe%3A%20function%20filtre%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3460048%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EPlease%20try%20to%20write%20first%20page%20name%20and%20%22!%22%20and%20combine%20it%20with%20wanted%20cell%20range.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3460090%22%20slang%3D%22en-US%22%3ERe%3A%20function%20filtre%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3460090%22%20slang%3D%22en-US%22%3Esame%20problem%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3460093%22%20slang%3D%22en-US%22%3ERe%3A%20function%20filtre%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3460093%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1411480%22%20target%3D%22_blank%22%3E%40safwen%3C%2FA%3E%26nbsp%3BRemove%20the%20other%20sheets%20name%20in%20the%20last%20argument%20of%20the%20formula%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Riny_van_Eekelen_0-1654176074742.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Riny_van_Eekelen_0-1654176074742.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Riny_van_Eekelen_0-1654176074742.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F377164i41A3282E59A8EEB8%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Riny_van_Eekelen_0-1654176074742.png%22%20alt%3D%22Riny_van_Eekelen_0-1654176074742.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Esince%20you%20want%20to%20filter%20for%20the%20value%20in%20A2%20of%20the%20active%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3460121%22%20slang%3D%22en-US%22%3ERe%3A%20function%20filtre%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3460121%22%20slang%3D%22en-US%22%3ERight%2C%20this%20is%20main%20reason.%20Safwen%20needs%20to%20remove%20filterer!%20and%20he%20must%20choose%20active%20sheet%20range%20then%20bam%3C%2FLINGO-BODY%3E
New Contributor

Hello guys please i have a question 
why when i try filtre function in the same sheet of table used in the function it works well but when i write it in other sheet it doesn't work.
what is the solution please 

safwen_0-1654174432900.pngsafwen_1-1654174446776.png

 

4 Replies
Hi,
Please try to write first page name and "!" and combine it with wanted cell range.
same problem

@safwen Remove the other sheets name in the last argument of the formula

 

Riny_van_Eekelen_0-1654176074742.png

since you want to filter for the value in A2 of the active sheet.

Right, this is main reason. Safwen needs to remove filterer! and he must choose active sheet range then bam