centers

I have cost centers in column A and amounts in column B. Cost centers are repeated so I want a formula to sum the amount for each cost center on column C. It is like doing pivot table. Thanks

Hi All, tried to look up the answer cause I know we covered this years ago 2005 ish. I needed to get same type answer/formula then but can't find the answer and can't remember how we did it. So here goes: I'm getting old and want to set up a will. I have a couple dollars in investments. have...

I have Cost centers in column G and interest in column Y, Cost centers are repeated and so interest rates accordingly, only one interest rate should be for one cost center, so if there are more than one rates there is an error, so for example <tbody> 411044924 5.280613 411044924 5.280613...

Hi simple ? need to center first row from A1 to G1 .Columns("A1:G1").HorizontalAlignment = xlCenter don't work .Columns("A:G").HorizontalAlignment = xlCenter works but centers everything from A to G Thanks