# running total of unique values

1. ## running total of unique values

Hello!

I need to help figuring out how to get a runing total of unique values. First column of data contains the values, the column to the right needs to display a running total of unique values.

Joanne

2. ## Re: running total of unique values

Put this formula in C3, then copy down:

=IF(ISNUMBER(MATCH(B3,\$B\$2:\$B2,0)),N(C2),N(C2)+1)

3. ## Re: running total of unique values

oh my god! how did you figure that out so fast!!!!

if you want a real tough one... i am trying to figure this one out that has been whipping my brain for days. I have it posted it here on the site that hasnt been solved yet.

Thank you so much!!
Joanne

4. ## Re: running total of unique values

Enter 1 in cell c3

enter this formula into C4 and fill down,

``Please Login or Register  to view this content.``

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1