Can I set a filter for a merged column across multiple rows and o.

M

Martin

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.
 
D

Debra Dalgleish

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

http://www.contextures.com/xlCondFormat03.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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Page numbering with Merged Document and IF statements 1
Multiple column scroll 5
Compressing multiple functions across an array into one cell 6
Lookup Across Multiple Rows / Columns 5
Copy/paste data across filtered rows 1
Create a list of unique entries based on several columns 1
Solution to tricky problem of showing exactly Top N rows in Pivottable 0

Top