Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex Lookup question. | Excel Worksheet Functions | |||
another complex =IF question | New Users to Excel | |||
how to identically size merged cells for filtering use | Excel Worksheet Functions | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
complex count question | Excel Worksheet Functions |