First question here. I'm a competent enough programmer but I'm wondering if there's an excel-like way to solve this. Lets say I have three columns: account #, date, expenditure. I want to see each accounts' expenditure via year. If I wanted to just see the gross total for all years per account, I know I could use the subtotal option. However, there doesn't seem to be an option to differentiate on more than one column (unlike the 'sort' function). What does SU recommend?

link|improve this question
feedback

1 Answer

up vote 1 down vote accepted

You can differentiate on more than one column in Excel. To do this, check each of your column names in the below window (under "Add subtotal to:"):

alt text

link|improve this answer
Thanks! Will come in handy. – jlv Nov 4 '10 at 13:13
You're welcome. – Mehper C. Palavuzlar Nov 4 '10 at 13:24
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.