Forum Discussion

Copper Contributor

Dec 19, 2017

Columns being done?

I'm new to Excel and the boss wanted this to be done: Take five columns row by row The first column contains a number of a check. This is what makes this row unique he says. The next column has...

excel

Haytham Amairah

Silver Contributor

Dec 19, 2017

Hi,

You said: "If this is a deposit then add this to the value that was in the fifth column and put that into the current row in the fifth column.

If this is a withdrawal then subtract this value from what was in the fifth column

and store it into the current row in the fifth column."

You cannot do all that stuff in one column (column 5)

You need a sixth column to put the formula in it!

Please provide us with a sample of your data.

rmccabe
Copper Contributor
Dec 19, 2017
Haytham:

Here's a sample of the data that the boss gave me. It's not in a sheet, but it shows you what he wanted done.

Check number Name Deposit Withdrawal Balance

000001 John Revere 500.00 500.00

000002 Paul Johnson 395.67

000003 Verizon 200.00

The first check was to be treated as a starting balance, so no problem there.

The rest of the task had me stumped,. If it takes more than five columns, the boss

would say okay, just get the job done. I'm new to Excel and really don't have much

experience with it . HELP!!