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

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/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

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 here:
>
> 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
>
>