Complex Question on Filtering on a merged column


L

Laura

D6Is there a way to filter a merged column and have the filtering options
span 6 seperate columns?

For example, the column header has been entered in a merged cells D1-I1.
The header is the only thing that is merged. Cells D2-D6 each have the value
"planner" written in them. Cells E2-E6 each have the value "design" writting
in them. it continues with F2-F6, G2-G6, H2-H6 and I2-I6. I would like to
filter on the merged cell (D1-I1) and have the values available to be
selected span D2-D6, E2-E6 and F2-F6, G2-G6, H2-H6 and I2-I6.

Please help!
 
Ad

Advertisements

S

Sheeloo

You can FILTER on merged cells.

If you do want to filter on the combined values of the cells then you can
have a formula like this one in the first blank columns and filter on that
column
=E2&F2&G2&H2...
and copied down...
 

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

Top