If F2 is -, then move that number to G2

[mrsellshomes]

I have bank statements that have some withdrawals (column G) in the deposit column (F). See example below. Can you PLEASE help me get these -$ figures into column G?! THANK YOU!!!

Post Date	Transaction Description	Account Number	Account NumberTransaction Description	Withdrawal	Deposit	Balance
Jan 01 2016	Previous Balance		Previous Balance			$1141.11
Jan 03 2016	Withdrawal Debit Card Signature Debit	Withdrawal Debit Card Signature Debit		-6	$1135.11

<colgroup><col><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>

 

[Peter_SSs]

Welcome to the MrExcel board!

I have bank statements that have some withdrawals (column G) in the deposit column (F). See example below. Can you PLEASE help me get these -$ figures into column G?! THANK YOU!!!

I presume that red G was meant to be an E. If so, try this in G3 and copy down

=SUM(G2,E3:F3)

 

[mrsellshomes]

Re: If E2 is -, then move that number to E2

My apologies! Yes. Withdrawals are in E. Deposits are in F. Some withdrawals are showing up in column F as - numbers. I need those to be moved to column E on the same row on if the number is negative in column F. Otherwise I need it to stay there. Tried the formula but it didn't work.

 

[Peter_SSs]

Re: If E2 is -, then move that number to E2

I need those to be moved to column E on the same row on if the number is negative in column F. Otherwise I need it to stay there.

Since a formula cannot remove a number from where it is, you must be looking for a macro?

Can you show us a slightly larger set of sample data so that we can see the variation in how it is arranged?

Also please show us the expected final result from that sample data so we know exactly what we are aiming for.

 

[mrsellshomes]

Re: If F2 is -, then move that number to E2

I would be good with them copied to a third column or moved to E. Either way. You'll see the -3.04 and -79.46 that appear in column F. Those should be in column E or copied to a third column. As long as that third takes the negatives already in E and the negatives in F (there will never be a negative in E and F on the same row). You can see the desired result in the third column below. Again, there isn't a negative in E AND F in any row. I have thousands of rows :/

Example

Post Date	Transaction Description	Account Number	Account NumberTransaction Description	Withdrawal	Deposit
	CU 9200 SE 82ND AVE HAPPY VALLEY OR	CU 9200 SE 82ND AVE HAPPY VALLEY OR
Jan 22 2016	Withdrawal POS #602303083491 POS SPACE AGE NO. 14	Withdrawal POS #602303083491 POS SPACE AGE NO. 14	-10.21
	CLACKAMAS OR		CLACKAMAS OR
Jan 23 2016	Withdrawal POS #602319735645 POS FRED MEYER FRED	Withdrawal POS #602319735645 POS FRED MEYER FRED	-76.39
	MEYER 143 HILLSBORO OR	MEYER 143 HILLSBORO OR
Jan 23 2016			-202.95
Jan 23 2016			-82.95
	SW BASELINE RUS HILLSBORO OR	SW BASELINE RUS HILLSBORO OR
Jan 23 2016	Withdrawal POS #602402397261 POS SPACE AGE NO. 14	Withdrawal POS #602402397261 POS SPACE AGE NO. 14	-3.04
	CLACKAMAS OR		CLACKAMAS OR
Jan 24 2016	Withdrawal Debit Card Signature Debit	Withdrawal Debit Card Signature Debit	-79.46
		6.02E+09	6.02E+09

<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>

Desired result

Post Date	Transaction Description	Account Number	Account NumberTransaction Description	Withdrawal	Deposit			or add to another column
	CU 9200 SE 82ND AVE HAPPY VALLEY OR	CU 9200 SE 82ND AVE HAPPY VALLEY OR
Jan 22 2016	Withdrawal POS #602303083491 POS SPACE AGE NO. 14	Withdrawal POS #602303083491 POS SPACE AGE NO. 14	-10.21				-10.21
	CLACKAMAS OR	CLACKAMAS OR
Jan 23 2016	Withdrawal POS #602319735645 POS FRED MEYER FRED	Withdrawal POS #602319735645 POS FRED MEYER FRED	-76.39				-76.39
	MEYER 143 HILLSBORO OR	MEYER 143 HILLSBORO OR
Jan 23 2016			-202.95				-202.95
Jan 23 2016			-82.95				-82.95
	SW BASELINE RUS HILLSBORO OR	SW BASELINE RUS HILLSBORO OR
Jan 23 2016	Withdrawal POS #602402397261 POS SPACE AGE NO. 14	Withdrawal POS #602402397261 POS SPACE AGE NO. 14			-3.04
	CLACKAMAS OR	CLACKAMAS OR
Jan 24 2016	Withdrawal Debit Card Signature Debit	Withdrawal Debit Card Signature Debit			-79.46

<colgroup><col span="9"></colgroup><tbody>
</tbody>

 

[Peter_SSs]

Re: If F2 is -, then move that number to E2

Since you are happy to have them in a third column then a formula could be used, as shown in H3, copied down.

Book1
	E	F	G	H
1	Withdrawal	Deposit
2
3	-10.21			-10.21
4
5	-76.39			-76.39
6
7	-202.95			-202.95
8	-82.95			-82.95
9
10		-3.04		-3.04
11
12		-79.46		-79.46
Collect Negatives

Cell Formulas
Range	Formula
H3	=IF(OR(E3<0,F3<0),MIN(E3:F3),"")

 

[mrsellshomes]

Re: If F2 is -, then move that number to E2

Yes!!!!! Thank you so much!!

 

[mrsellshomes]

Re: If F2 is -, then move that number to E2

Now I guess I just have to remove the negatives from F Forgot about that part :/

 

[Peter_SSs]

Re: If F2 is -, then move that number to E2

Now I guess I just have to remove the negatives from F Forgot about that part :/

Like this?

Book1
	E	F	G	H	I
1	Withdrawal	Deposit		Withdrawal	Deposit
2
3	-10.21			-10.21
4		25			25
5	-76.39			-76.39
6
7	-202.95			-202.95
8	-82.95			-82.95
9		100			100
10		-3.04		-3.04
11		2.23			2.23
12		-79.46		-79.46
Collect Negatives

Cell Formulas
Range	Formula
H3	=IF(OR(E3<0,F3<0),MIN(E3:F3),"")
I3	=IF(OR(F3="",F3<0),"",F3)