Forum Discussion
Solved
Filter with line merged
Hello, Under Excel, I would like to filter a table where some lines are merged. The lines are merged by two lines for the first three columns. When I have filter one of the first three columns,...
The technique could be
- copy / paste column you'd like to filter into another one
- unmerge Name column, on ribbon Home -> Find and Select -> Go to Special -> select Blanks
- type =B4
and Ctrl+Enter
- select column where you copy Names, Format Painter
and apply it to Name column
Now you may filter on Name
The technique could be
- copy / paste column you'd like to filter into another one
- unmerge Name column, on ribbon Home -> Find and Select -> Go to Special -> select Blanks
- type =B4
and Ctrl+Enter
- select column where you copy Names, Format Painter
and apply it to Name column
Now you may filter on Name
WonderFull
Glad to help. I believe such approach is described in few posts, you may google for them to check more step-by-step details