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

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

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

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

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

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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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

Many thanks, this works fine.

"Debra Dalgleish" wrote:

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

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

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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html