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
Bookmarks