Re: $$Excel-Macros$$ Re: Running Count for particular data

2010-07-05 Thread WizExcel
Thanks Aindril , However the countif is not working correctly for my case, for instance , in the file you have sent check Sr. No. 5 of the Punjab National Bank --- there the Count Should be 1 as Punjab National Bank is appearing for the first time and so on. On Jul 5, 9:05 pm, Aindril De wro

Re: $$Excel-Macros$$ Re: Running Count for particular data

2010-07-05 Thread Aindril De
Hi Sameer, PFA the solution, Regards, Aindril On Mon, Jul 5, 2010 at 6:00 PM, Sameer Wagh wrote: > I want avoid sorting the data as far as possible . > > thanks > > > On Mon, Jul 5, 2010 at 5:49 PM, WizExcel wrote: > >> Dear Experts, >> >> want to know if there is way / function for having a

$$Excel-Macros$$ Re: Running Count for particular data

2010-07-05 Thread Sameer Wagh
I want avoid sorting the data as far as possible . thanks On Mon, Jul 5, 2010 at 5:49 PM, WizExcel wrote: > Dear Experts, > > want to know if there is way / function for having a "running" count > in Excel. I have tried COUNTIF and most of the Count Functions , but > all give "total" count and