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 <aind...@gmail.com> wrote: > Hi Sameer, > > PFA the solution, > > Regards, > Aindril > > > > On Mon, Jul 5, 2010 at 6:00 PM, Sameer Wagh <ssw...@gmail.com> wrote: > > I want avoid sorting the data as far as possible . > > > thanks > > > On Mon, Jul 5, 2010 at 5:49 PM, WizExcel <ssw...@gmail.com> 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 not the "Running" Count. > > >> Example: See below. > > >> The Count for HDFC Bank should be 1, 2 ..... and then finally 3. and > >> then similarly for other Banks. What the CountIF function shows is the > >> TOTAL count. > > >> How it is happening now using CountIF: > > >> Bank Count > >> HFDC Bank 3 > >> SBI Bank 2 > >> SBI Bank 2 > >> HDFC Bank 3 > >> Axis Bank 1 > >> HDFC Bank 3 > > >> How I want it : > > >> Bank Count > >> HFDC Bank 1 > >> SBI Bank 1 > >> SBI Bank 2 > >> HDFC Bank 2 > >> Axis Bank 1 > >> HDFC Bank 3 > > > -- > > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 7000 subscribers worldwide and receive many nice notes about > > the learning and support from the group.Let friends and co-workers know they > > can subscribe to group at > >http://groups.google.com/group/excel-macros/subscribe > > > > Count_Problem.xlsx > 17KViewDownload- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
