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