han77729
New member
- Joined
- Dec 12, 2012
- Messages
- 31
- Reaction score
- 0
- Points
- 0
Hello All,
I'm trying to do a filter on a spreadsheet where I have multiple columns and rows. (duh) So the problem is that on some rows and columns I have just a single cell, which is fine.. but some columns I have multiple rows as one row. I honestly don't even know how to explain this.. so please view the attached spreadsheet for example.
When I try to filter, there was no problem with the headers BUT it does not pick up the second row of dates within that row.. if that makes sense. If I filter it by aircraft.. how can it pick up both of the dates. If there's not solution for this, is there an alternative?
Thanks as always,
View attachment Filter:Merging Cell.xlsx
I'm trying to do a filter on a spreadsheet where I have multiple columns and rows. (duh) So the problem is that on some rows and columns I have just a single cell, which is fine.. but some columns I have multiple rows as one row. I honestly don't even know how to explain this.. so please view the attached spreadsheet for example.
When I try to filter, there was no problem with the headers BUT it does not pick up the second row of dates within that row.. if that makes sense. If I filter it by aircraft.. how can it pick up both of the dates. If there's not solution for this, is there an alternative?
Thanks as always,
View attachment Filter:Merging Cell.xlsx