Excel 2010; Need help w/If, Then formula

tmsblevis Posts 1 Registration date Wednesday June 5, 2013 Status Member Last seen June 5, 2013 - Jun 5, 2013 at 03:17 PM
 Blocked Profile - Jun 5, 2013 at 04:14 PM
I need a formula that if there are duplicate values in column A, then it will sum the values in column D for the rows with duplicate values in column A and return the sum in the first of the duplicate rows in column C and delete the row with the duplicate in column A.

A7 = 35060, A8 = 35060, then D7+D8 and return sum to c7, then delete row 8.

I am a neophite with formulas and macros so I'm sorry if this sounds more convoluted than it needs to be.

Any help would be great!

1 response

Blocked Profile
Jun 5, 2013 at 04:14 PM
Good afternoon, The excel "if then" statement if structured as such....
=if(logical condition to check, true, false)

If you wish to loop if/then, then nest it in the false portion and make a second test for logic....so something like...
=if(E1=1,"e1=1",if(E1=2,"E1=2","E1 is not 1 or 2"))

This would be a formula in a cell, not a VBA macro.

Think it through based on the example.