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
A pre-prepared template would be an advantage
... however try this formula
=A2&","&B2&","&C3&","&D4
Nikolino
I know I don't know anything (Socrates)
... however try this formula
=A2&","&B2&","&C3&","&D4
Nikolino
I know I don't know anything (Socrates)