Forum Discussion
Hursh Patel
Oct 13, 2019Copper Contributor
HELP EXCEL FILTER ROWS
Hello, Im trying to build an excel a sheet that auto hides rows based on a drop down selection how do I hide rows automatically based on the drop down menu? For instance - Hires Row...
Patrick2788
Oct 18, 2019Silver Contributor
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
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