Hi All,
Below is a sample excel format. I enabled merge cells from A1..A5 and B7..B10. I enabled autofilter and when I filter with column A(Cat), I can see only one value of the corresponding column B. How can I view all values of B when filtered with A? (Auto filter with merged cells) will work?
A B
Cat Val
21
22
a 23
24
25
12
34
b 56
30
Thankx
Bookmarks