Thread: Running Count
View Single Post
  #2   Report Post  
David Billigmeier
 
Posts: n/a
Default

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