Duplicate Filter from Table to another Sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1969919%22%20slang%3D%22en-US%22%3EDuplicate%20Filter%20from%20Table%20to%20another%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1969919%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20formatted%20table%20example%20below%2C%20and%20I%20would%20like%20the%20filter%20function%20to%20be%20duplicated%20in%20another%20sheet%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22zyc93_1-1607497593921.png%22%20style%3D%22width%3A%20273px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F238949i877ED1AB61B42F2D%2Fimage-dimensions%2F273x181%3Fv%3D1.0%22%20width%3D%22273%22%20height%3D%22181%22%20role%3D%22button%22%20title%3D%22zyc93_1-1607497593921.png%22%20alt%3D%22zyc93_1-1607497593921.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20only%20like%20the%20filter%20function%20for%20%22User%22%20to%20be%20duplicated%20on%20another%20sheet.%20So%20the%20user%20of%20the%20file%20could%20filter%20only%20by%20%22User%22%2C%20and%20the%20rest%20of%20the%20main%20table%20would%20be%20filtered%20accordingly.%20Is%20this%20even%20possible%3F%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%22zyc93_2-1607497641213.png%22%20style%3D%22width%3A%20259px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F238950iFB4504C19B54CD4E%2Fimage-dimensions%2F259x427%3Fv%3D1.0%22%20width%3D%22259%22%20height%3D%22427%22%20role%3D%22button%22%20title%3D%22zyc93_2-1607497641213.png%22%20alt%3D%22zyc93_2-1607497641213.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EP.S.%20I%20understand%20that%20you%20can%20create%20a%20slicer%20to%20filter%2C%20but%20I%20have%20many%20unique%20values%20in%20the%20%22User%22%20column%2C%20and%20would%20like%20for%20it%20to%20be%20searchable.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1969919%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I have a formatted table example below, and I would like the filter function to be duplicated in another sheet:

zyc93_1-1607497593921.png

 

I would only like the filter function for "User" to be duplicated on another sheet. So the user of the file could filter only by "User", and the rest of the main table would be filtered accordingly. Is this even possible?

 

zyc93_2-1607497641213.png

 

P.S. I understand that you can create a slicer to filter, but I have many unique values in the "User" column, and would like for it to be searchable. 

 

 

 

 

1 Reply

@zyc93 Hi

You may achieve it using below Filter function:

=FILTER(A2:C7,B2:B7=F1)

 

tauqeeracma_0-1607501124990.png

Users will be selected from a separate list that will bring filtered data accordingly.

 

Hope it will help

 

Thanks

Tauqeer