filtering query

Hi there,

I have a query about filtering merge cells.

I have say 8 rows of information over a number of columns. 4 rows are for one project, let's say project-x, and the other 4 rows are for another project, let's say project-y.

Rather than typing project-x or project-y in each row, I have merged the 4 cells in one column, which reads project-x, and merged the other 4 cells below, which reads project-y.

When I filter by project-x, only row 1 information shows up. When I filter by project-y, only row 5 information shows up, no other rows.

Any assistance would be greatly appreciated.

Cheers

Well, the short answer is not to use merged cells. It might look like the data is spread across those 4 cells, but in fact the data is only in the first cell of the block, as you have found.

Hope this helps.

Pete

Here's a tinker to workaround the problem of vertically merged cells
Assume your merged cells are in A2 down, eg in A2:A5, A6:A9, etc
Insert a new col A
Put in A2: =B2
Put in A3: =IF(B3="",A2,B3)
Copy A3 all the way down to populate it all in one sweep
Now you can apply filter on the new col A

p/s: Instead of using merged cells, note that you can easily enter at one go the same input into multiple cells via CTRL+ENTER. Just select the 4 vertical cells eg A2:A5, type the input into the formula bar, press CTRL+ENTER
---------------------------------------------
Any good? Wave it, hit the little star at the bottom left of my responses