Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cash Book
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cash Book
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 "Freddo" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Petty Cash form to return -/+ amount? | Excel Worksheet Functions | |||
Could you recommend an Excel book? | Excel Discussion (Misc queries) | |||
book selection when using move or copy tab in excel | Excel Worksheet Functions | |||
Work book formulas | Excel Discussion (Misc queries) | |||
Need a simple Secretaries Cash Book | Excel Discussion (Misc queries) |