Forum Discussion

OJSADFJ1's avatar
OJSADFJ1
Copper Contributor
Jun 10, 2024

Filter using a drop-down list.

I have a sheet that I want to filter using a drop-down list. Column A is what I want to filter the sheet by which is a column with the appropriate week number and the drop-down list I want to use is ...
excel
Macros and VBA
Harun24HR's avatar
Harun24HR
Bronze Contributor
Jun 10, 2024
If you have Microsoft-365 then could use FILTER() function.
OJSADFJ1's avatar
OJSADFJ1
Copper Contributor
Jun 10, 2024

The filter() function gets rid of the formatting I have. I would like to keep the formatting with the merged cells and everything. Harun24HR 

Resources