Excel search table

%3CLINGO-SUB%20id%3D%22lingo-sub-2770563%22%20slang%3D%22en-US%22%3EExcel%20search%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2770563%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20table%26nbsp%3B%20with%20three%20columns%2C%20the%201st%20column%20has%20part%20models.%26nbsp%3B%20Second%20column%20has%20machine%20process%20types%20or%20systems%20and%20the%20third%20column%20has%20the%20name%20of%20the%20machines.%26nbsp%3B%20I%20created%20a%20search%20field%20at%20the%20top%20so%20a%20person%20can%20enter%20the%20part%20model%20and%20it%20highlights%20the%20cell%20below%20but%20what%20the%20operators%20would%20like%20to%20only%20see%20is%20the%20search%20field%20at%20the%20top%2C%20like%20created%20and%20process%20type%20cell%20and%20machine%20type%20cell%20right%20after%20the%20search%20box.%26nbsp%3B%20Then%20hide%20data%20table%20below.%26nbsp%3B%20Just%20not%20sure%20what%20formula%20to%20use%20to%20get%20a%20search%20field%20cell%20and%20the%20support%20data%20cells%20to%20show.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2770563%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-2770764%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20search%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2770764%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1162227%22%20target%3D%22_blank%22%3E%40Bruce1975%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFilter.%20*%3C%2FP%3E%3CP%3EAdvanced%20filter.%3C%2FP%3E%3CP%3EFILTER().%3C%2FP%3E%3CP%3EPivot%20table.%20*%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20alternatively%20with%20slicers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have an excel table  with three columns, the 1st column has part models.  Second column has machine process types or systems and the third column has the name of the machines.  I created a search field at the top so a person can enter the part model and it highlights the cell below but what the operators would like to only see is the search field at the top, like created and process type cell and machine type cell right after the search box.  Then hide data table below.  Just not sure what formula to use to get a search field cell and the support data cells to show.

1 Reply

@Bruce1975 

Filter. *

Advanced filter.

FILTER().

Pivot table. *

 

* alternatively with slicers