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.
>
> > On Jul 5, 8:16 pm, Ayush wrote:
> > > Than
Good!
On Tue, Jul 6, 2010 at 8:55 AM, WizExcel wrote:
> This is just too good Ayush ,
> thanks for the explanation.
>
>
> On Jul 5, 8:16 pm, Ayush wrote:
> > Thanks Ankit.
> > As the running count was required, The formula should have running
> > range. I have used Row f(x) to return the curren
This is just too good Ayush ,
thanks for the explanation.
On Jul 5, 8:16 pm, Ayush wrote:
> Thanks Ankit.
> As the running count was required, The formula should have running
> range. I have used Row f(x) to return the current row number and used
> the indirect f(x) to convert the test string in
Thanks Ayush
On Mon, Jul 5, 2010 at 8:46 PM, Ayush wrote:
> Thanks Ankit.
> As the running count was required, The formula should have running
> range. I have used Row f(x) to return the current row number and used
> the indirect f(x) to convert the test string into range.
> The two function
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$" & ROW(A2)),A2)*
>
> Please let us know
Thanks Ankit.
As the running count was required, The formula should have running
range. I have used Row f(x) to return the current row number and used
the indirect f(x) to convert the test string into range.
The two functions returns the running range and countif formula is
used to count the values
Hi Ayush,
This formula is perfect. I would appreciate if you would pls. explain 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.
>
> The formula is :- *=CO
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$" & ROW(A2)),A2)*
Please let us know if any further assistance is required.
Best regards,
Ayush Jain
Group Manager
On Mon, Jul 5, 2010 at
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
