How do I filter columns of merged cells to show all related rows?

[Guest]

Need to allow filtering of a column with merged cells to show the rows
associated with each merged cell

 

[Debra Dalgleish]

Instead of merging the cells, you could enter the value in each cell,
then use conditional formatting to hide the duplicates. There are
instructions here:

http://www.contextures.com/xlCondFormat03.html#Duplicate

 

[Guest]

Many thanks, this works fine.

Instead of merging the cells, you could enter the value in each cell,
then use conditional formatting to hide the duplicates. There are
instructions here:

http://www.contextures.com/xlCondFormat03.html#Duplicate