I put autofilter on for example column A which has merged cells(A1+A2 , A3+A4
, ...).when I use autofilter on it excell just filter the first rows of the
selected item.for example if I use autofilter and select a number which is in
merged cell(A1+A2)it just show the information in rows 1 and don't show info
in rows 2.How can I solve this?