$$Excel-Macros$$ Re: NUMBER STORED AS TEXT

2008-12-23 Thread Gaurav Kohli
HI ALL, I have a Excel table having the following fields. Column A contain Dates and column B contains Product Name. I need a macro which will count the values based on Multiple criteria. I am able to accomplish the desired task using an excel formula i.e. =SUMPRODUCT((A$1:A1$0=A1)*(B$1:B1$0=B1)

$$Excel-Macros$$ Re: BOOK FOR WRITING UP MACROS

2008-12-13 Thread Gaurav Kohli
I also need this book..thanks in advance On Sat, Dec 13, 2008 at 5:42 PM, Arun Kalra wrote: > Could you please forward that book to me as well? > > My id is kalra.a...@rediffmail.com > > On Tue, Jul 29, 2008 at 2:38 PM, rajzoo1 wrote: > >> >> whats the password. >> >> On Jul 9, 9:47 am, swapnils