Running Count

briank -
Assume your 'Amount' values begin in A1 and you want your running count to
be in column B, place this formula in B1 and drag down:

=COUNTIF($A$1:A1,A1)

--
Regards,
Dave


"briank" wrote:

> I have a spreadsheet with two columns: Amount and RunCt. I would like to get
> a function to show a running count of unique dollar amount that shows up in
> the RunCt column. Any thoughts on how to do this?
>
> Amount RunCt
> $100 1
> $200 1
> $100 2
> $50 1
> $100 3

Try this in B2:

=COUNTIF($A$2:A2,A2)

And copy down as needed.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"briank" <[email protected]> wrote in message
news:[email protected]...
> I have a spreadsheet with two columns: Amount and RunCt. I would like to
get
> a function to show a running count of unique dollar amount that shows up
in
> the RunCt column. Any thoughts on how to do this?
>
> Amount RunCt
> $100 1
> $200 1
> $100 2
> $50 1
> $100 3

briank -
Assume your 'Amount' values begin in A1 and you want your running count to
be in column B, place this formula in B1 and drag down:

=COUNTIF($A$1:A1,A1)

--
Regards,
Dave


"briank" wrote:

> I have a spreadsheet with two columns: Amount and RunCt. I would like to get
> a function to show a running count of unique dollar amount that shows up in
> the RunCt column. Any thoughts on how to do this?
>
> Amount RunCt
> $100 1
> $200 1
> $100 2
> $50 1
> $100 3

Try this in B2:

=COUNTIF($A$2:A2,A2)

And copy down as needed.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"briank" <[email protected]> wrote in message
news:[email protected]...
> I have a spreadsheet with two columns: Amount and RunCt. I would like to
get
> a function to show a running count of unique dollar amount that shows up
in
> the RunCt column. Any thoughts on how to do this?
>
> Amount RunCt
> $100 1
> $200 1
> $100 2
> $50 1
> $100 3

Dave,
Thanks a bunch - your formula worked gr8!

"David Billigmeier" wrote:

> briank -
> Assume your 'Amount' values begin in A1 and you want your running count to
> be in column B, place this formula in B1 and drag down:
>
> =COUNTIF($A$1:A1,A1)
>
> --
> Regards,
> Dave
>
>
> "briank" wrote:
>
> > I have a spreadsheet with two columns: Amount and RunCt. I would like to get
> > a function to show a running count of unique dollar amount that shows up in
> > the RunCt column. Any thoughts on how to do this?
> >
> > Amount RunCt
> > $100 1
> > $200 1
> > $100 2
> > $50 1
> > $100 3

I have a spreadsheet with two columns: Amount and RunCt. I would like to get
a function to show a running count of unique dollar amount that shows up in
the RunCt column. Any thoughts on how to do this?

Amount RunCt
$100 1
$200 1
$100 2
$50 1
$100 3

briank -
Assume your 'Amount' values begin in A1 and you want your running count to
be in column B, place this formula in B1 and drag down:

=COUNTIF($A$1:A1,A1)

--
Regards,
Dave


"briank" wrote:

> I have a spreadsheet with two columns: Amount and RunCt. I would like to get
> a function to show a running count of unique dollar amount that shows up in
> the RunCt column. Any thoughts on how to do this?
>
> Amount RunCt
> $100 1
> $200 1
> $100 2
> $50 1
> $100 3

Try this in B2:

=COUNTIF($A$2:A2,A2)

And copy down as needed.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"briank" <[email protected]> wrote in message
news:[email protected]...
> I have a spreadsheet with two columns: Amount and RunCt. I would like to
get
> a function to show a running count of unique dollar amount that shows up
in
> the RunCt column. Any thoughts on how to do this?
>
> Amount RunCt
> $100 1
> $200 1
> $100 2
> $50 1
> $100 3

Dave,
Thanks a bunch - your formula worked gr8!

"David Billigmeier" wrote:

> briank -
> Assume your 'Amount' values begin in A1 and you want your running count to
> be in column B, place this formula in B1 and drag down:
>
> =COUNTIF($A$1:A1,A1)
>
> --
> Regards,
> Dave
>
>
> "briank" wrote:
>
> > I have a spreadsheet with two columns: Amount and RunCt. I would like to get
> > a function to show a running count of unique dollar amount that shows up in
> > the RunCt column. Any thoughts on how to do this?
> >
> > Amount RunCt
> > $100 1
> > $200 1
> > $100 2
> > $50 1
> > $100 3