Also POssible using this simple formula :
=COUNTIF($B$3:B5,B5)
regards,
On Jul 6, 11:13 am, SAJID MANSOOR wrote:
> Good!
>
>
>
> On Tue, Jul 6, 2010 at 8:55 AM, WizExcel wrote:
> > This is just too good Ayush ,
> > thanks for the explanation.
>
>
ain it.
>
> > Thanks,
> > Ankit
>
> > On Mon, Jul 5, 2010 at 7:56 PM, ayush jain wrote:
> > > Hi Wizexcel,
>
> > > Attached is the solution. You have to use the combination of countif,
> > > indirect and row function.
>
> > &g
wrote:
> 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
Thanks Ayush ,
really appreciate the quick response
On Jul 5, 7:26 pm, ayush jain wrote:
> Hi Wizexcel,
>
> Attached is the solution. You have to use the combination of countif,
> indirect and row function.
>
> The formula is :- *=COUNTIF(INDIRECT("$A$2:$A$" &
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
the
Hi Rahul,
is it possible to do the reverse?, Suppose i create a new sheet and
paste some data in it . Now i want to name this sheet with the
contents of a particular cell,
say, cell D15 is 'May 15- Action Points', I want to name my sheet as
this 'May 15- Action Points'
thanks
Sameer
On May 2
Paul ,
it would be really helpful if you let me know if there is any way in
which we can do this :
Filter a data on say Column A (column A data has 10 unique values )
first, then on Column B (But this column No. of values keep on
changing, sometimes 9 , sometimes 10, 11,) and then prepare separat
This is Superb Mahesh. really helpful for anyone who wants to send
repetitive emails to a list of persons.
Can anyone please also tell me its utility from Finance Dept. point of
view, what functions have you used this Macro for.
thanks
Sameer
On May 15, 10:49 am, Mahesh parab wrote:
> Hi
> In
