Forum Discussion
Display/hide rows based on dropdown list
Good day folks, I have data in the worksheet as per the following: Introduction (Row 1 to 9) City of Toronto (Row 10-19) City of Winnipeg(Row20-29) City of Vancouver(Row 30-39) City of Montre...
I suggest you turn it into a table and use a filter or slicer.
Another option would be to create a pivot table and use a filter field
and lastly you could 'hide' all the data either in hidden rows or even on another sheet and then use FILTER() to pull and show the relevant data.
Another option would be to create a pivot table and use a filter field
and lastly you could 'hide' all the data either in hidden rows or even on another sheet and then use FILTER() to pull and show the relevant data.
