Can I set a filter for a merged column across multiple rows and on selection
of a value on the merged column get all the corresponding rows. Currently it
just returns only the first row.

Hi
AFAIK this is not possible

--
Regards
Frank Kabel
Frankfurt, Germany


Martin wrote:
Can I set a filter for a merged column across multiple rows and on
selection of a value on the merged column get all the corresponding
rows. Currently it just returns only the first row.

Instead of merging the rows in one of the columns, you could enter the
value in each row. Then, hide the duplicates with conditional
formatting, as described he

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

When you filter, all the rows for the selected items will be visible.

Or, instead of using multiple rows per item, enter all the data in one
row, and it will be easier to manage.

Martin wrote:
Can I set a filter for a merged column across multiple rows and on selection
of a value on the merged column get all the corresponding rows. Currently it
just returns only the first row.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html