close

I subtotaled (sum) on 3 columns based on changes in a 4th column. There is a
5th column (repeating text info in all cells in the subtotaled groups) that I
want to display in the subtotaled (level 2) row. How do I get it to show?

Hi
Go to Data/Subtotals again and select the subtotal requirement. Make sure
you uncheck 'Replace current subtotals' before you click OK.

Andy.

quot;grjkquot; gt; wrote in message
...
gt;I subtotaled (sum) on 3 columns based on changes in a 4th column. There is
gt;a
gt; 5th column (repeating text info in all cells in the subtotaled groups)
gt; that I
gt; want to display in the subtotaled (level 2) row. How do I get it to show?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()