Running Count

B

briank

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
 
D

David Billigmeier

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)
 
R

RagDyer

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!
==============================================
 
B

briank

Dave,
Thanks a bunch - your formula worked gr8!

David Billigmeier said:
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)
Click to expand...
 
Top