Filtering on merged cells

  • Thread starter Thread starter mtaylor
  • Start date Start date
M

mtaylor

Can you please help?

I have 6 pieces of info in cells A8, A9, A10, A11, A12 & A13 - Cells C8
to C13 are merged and contain one value, if i use the filter option and
choose the value contained within the merged cells, it only displays
the info in cell A8, where as i need the info in cells A8, A9, A10,
A11, A12 & A13 to be shown...is this possible?

Thanks
 
I don't think so.

You could remove the merged cells, but populate the rest of formerly merged area
with the same value, but use format|conditional formatting so it looks like
those cells are empty.

Debra Dalgleish shows a way to fill those empty cells with the value above (if
you have lots) at:
http://contextures.com/xlDataEntry02.html

And she shows how to use conditional formatting to hide those "duplicated"
values at:
http://contextures.com/xlCondFormat03.html#Duplicate
 
Back
Top