Cash Book

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing a cash book on excel I want to be able to put the amount in say
column B and a description say in column C, then I went the the figure to be
automatically to be transferred to the apprpiate coulmn which will have the
same heading as the description. In other words I want to analyse the
information
 
With your description in Column C, and the amount in Column B, and your
various headings in Row 1 across. In D2 enter =IF(C2=$D$1,B2,"") and copy
down. In E2 enter =IF(D2=$E$1,B2,"") and copy down, etc.
If you have description Refreshments in say E1, and the same in D2, it will
reflect the amount spent in E2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running Total, Opening & Closing Acct Balance in Cash Book 1
putting number against certain words formula 0
Excel cash book: formula to duplicate amt in relevant exp column 1
hidden rows problem 7
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 7
FORMULA HELP ! ! 1
Male v. Female At The Cash Machine 2
Cash Flows Inflation Adjusted 2

Back
Top