Re: $$Excel-Macros$$ formula required for addition of amount for duplicate entry

2012-10-09 Thread ashish koul
can you show us how do you want to see output On Tue, Oct 9, 2012 at 1:16 PM, ashish damor wrote: > Dear All, > > I have an excel sheet wherein commission is generated for each > business placed by our intermediary. I need to have a formula for > monthly consolidated amount for Gross Amount (Col

$$Excel-Macros$$ formula required for addition of amount for duplicate entry

2012-10-09 Thread ashish damor
Dear All, I have an excel sheet wherein commission is generated for each business placed by our intermediary. I need to have a formula for monthly consolidated amount for Gross Amount (Column E) and TDS Deduction (Column I) of each intermediary without first sorting and subsequently adding each en