Autofilter used with merged cells
Excel 2003, sp2
Hi,
I have a table with quarters in column A. Each quarter has its related
months in column B. The cells in column A that represent each quarter are
merged - I don't want the quarters repeated for each month.. When I apply
the autofilter and filter col A only the first month in col B is displayed.
However I want all 3 related month to be displayed.
One work-around that works is to unmerge the cells in col A and enter
quarter values for each month in column B and change the text color for the
duplicate quarter values to white. The "hidden" values are however visible
to the user if he selects the cells.
Is there a way to solve this which lets me keep the merged quarters in col
A?
Regards
Pete
|