Excel 2010; Need help w/If, Then formula
Closed
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
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.
e.g.
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!
e.g.
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!
Related:
- Excel 2010; Need help w/If, Then formula
- Microsoft office 2010 free download - Download - Office suites
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Save as pdf office 2010 - Download - Other
1 response
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.
=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.
