HELP EXCEL FILTER ROWS

Question

Hello,&nbsp;Im trying to build an excel a sheet that auto hides rows based on a drop down selection&nbsp;how do I hide rows automatically based on the drop down menu?&nbsp;For instance -&nbsp;&nbsp;HiresRow 1-10 viewable and it hides 11-20&nbsp;TerminationsRow 11-20 viewable and hides row 1-10?

patrick2788 · Answer

The new FILTER function is your solution.

https://support.office.com/client/results?HelpID=xlmain11.chm60662&lcid=1033&syslcid=1033&uilcid=1033&ShowNav=true&VERSION=90&NS=EXCEL&app=webview&context=%7BAppVersionMajor%3A16%2CAppVersionMinor%3A0%2CAppVersionBuild%3A11929%2CAppVersionUpdate%3A20002%7D

Forum Discussion

HELP EXCEL FILTER ROWS

1 Reply

Resources