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" wrote in message
...
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