T accounts - formula to auto complete

Hi,

I have a problem and I am sure there is a smart way to achieve what I need to do.

I have a data table and I need to move the data into T accounts based on the account number and weather it is a + or -. If it is a “+” it should appear on the right hand side of the data table and left if it’s a “-“

In the attached example I have dummy data where I have a small data table and 3 different accounts. On the “T accounts” tab I have manually reference the data tab.

What I require is a formula to do this instead where it allocates each line automatically where it matches the account number to the T account account number.

Can this be done?

For ref there is a unique record ID on the data tab if that helps?

Hi, thanks for this - it works I can see in the first account.

When I move it to the other accounts do I need to change the row reference to A1?

Is the only different between the formulas in C and P the "+" and ="-" parts? Im only asking as I am about to start copying the formula to other 300 accounts

I must be doing something wrong ACE - on the attached I have copied over your fomrula but I have "+" and "-" appearing on both sides.

Ok - thats a quick and easy fix!

Thanks for this - now to replicate it a few hunreded times - wish me luck lol

Hi,

To be honest it doesnt seem like it will take me too long. I do have another thing I have just thought of but I will prepare an example file and upload to a new thread