Complex Question on Filtering on a merged column
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! |
Complex Question on Filtering on a merged column
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... "Laura" wrote: 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! |
All times are GMT +1. The time now is 11:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com