Is there a way to filter in two dimensions using Filter Function?

%3CLINGO-SUB%20id%3D%22lingo-sub-1606109%22%20slang%3D%22en-US%22%3EIs%20there%20a%20way%20to%20filter%20in%20two%20dimensions%20using%20Filter%20Function%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606109%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20a%20large%20table%20I%20need%20to%20sort%20values%20from%20in%20both%20lines%20and%20columns.%20I%20found%20Filter%20Function%20is%20almost%20what%20I%20need%2C%20but%20I%20could%20only%20filter%20lines%20OR%20columns%20out%20of%20the%20original%20table.%20Is%20there%20a%20way%20to%20filter%20in%20both%20dimensions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1606126%22%20slang%3D%22en-US%22%3ERE%3A%20Is%20there%20a%20way%20to%20filter%20in%20two%20dimensions%20using%20Filter%20Function%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606126%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffilter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759%3Fns%3Dexcel%26amp%3Bversion%3D90%26amp%3Bsyslcid%3D1033%26amp%3Builcid%3D1033%26amp%3Bappver%3Dzxl900%26amp%3Bhelpid%3Dxlmain11.chm60662%26amp%3Bui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffilter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759%3Fns%3Dexcel%26amp%3Bversion%3D90%26amp%3Bsyslcid%3D1033%26amp%3Builcid%3D1033%26amp%3Bappver%3Dzxl900%26amp%3Bhelpid%3Dxlmain11.chm60662%26amp%3Bui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Visitor

Hi,

I have a large table I need to sort values from in both lines and columns. I found Filter Function is almost what I need, but I could only filter lines OR columns out of the original table. Is there a way to filter in both dimensions?

1 Reply