Forum Discussion
Formula using cells from another sheet
I know the most basic formulas which I why I need help with a more advanced one. My spreadsheet has 2 tabs. One is a check register with a dollar amount in one column and a description of the transa...
You don't need a formula. You need to employ the Pivot Table, which enables Excel to do the work for you. See the attached example as well as the resource there in the hyperlink