Re: $$Excel-Macros$$ Combining mulitple rows into one row

2010-01-12 Thread ankur
hi Always Learning SUMPRODUCT will help you .Try it out On 1/12/10, Dilip Pandey wrote: > Hi, > > Yes this can be done. > > Try using SumProduct or SumIF or DSUM function to get this done. > For more clarification, please attach a test file. > > Best Regards, > -- > DILIP KUMAR PANDEY > MBA-HR

Re: $$Excel-Macros$$ Combining mulitple rows into one row

2010-01-12 Thread Dilip Pandey
Hi, Yes this can be done. Try using SumProduct or SumIF or DSUM function to get this done. For more clarification, please attach a test file. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tu

Re: $$Excel-Macros$$ Combining mulitple rows into one row

2010-01-12 Thread Sachin Shukla
Dear, PFA soluation. Thanks sachin shukla On 1/12/10, AlwaysLearing wrote: > > Hey Guys, > I have a spreadsheet that has multiple rows of data for each employee > with each row containing the date they worked and for how long. For > example, Mr. Smith worked on 7/1/09 for 8 hrs and on 7/2/09