Forum Discussion
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, Excel show only the first line of the merged line, why ?
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
8 Replies
- A demo file would help you solve the problem faster.
HelloNikolinoDE
You can find in attachment file a example.
When I filter by name, I would like to show two lines.
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
LE_TOULLEC , this is normal Excel behavior. If cells A2 and A3 are merged, only cell A2 will have the value. You can test this by typing =A2 in B3 and =A3 in B3.
IMHO, merged cells are nothing but trouble. I'd recommend removing them and repeating the items.
- 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)
