Excel cash book: formula to duplicate amt in relevant exp column
 

Cash book: what formula would work to duplicate an amount in one (total
expense) column, to the relevant expense column, using a simple chart of
accounts/code number to identify which expense.

Excel cash book: formula to duplicate amt in relevant exp column
 

Imagine you have data laid out like this in row 1:

Date Descr Amount Code 1001 1002 1003 etc.

You enter data into the first 4 columns. Then in E2 you can have a formula
like this:

=IF($D2=E$1,$C2,0)

Copy this across the row for as many columns as you need, then copy all
these formulae down for as many rows as you need.

Hope this helps.

Pete

"quilta" wrote in message
...
Cash book: what formula would work to duplicate an amount in one (total
expense) column, to the relevant expense column, using a simple chart of
accounts/code number to identify which expense.