if your list of data (some data = duplicated data) are stored in C3:C26
then *The Count of Unique Values *is
*=SUM(1/(COUNTIF(C3:C26,C3:C26)))*
best regards
siti
On Tue, Oct 12, 2010 at 7:13 AM, MikeMikeMike
wrote:
>
> I am having a problem with a forumla I am hoping someone out there can
>
I am having a problem with a forumla I am hoping someone out there can
help me with.
What I am trying to do is use a vlookup to give me the amount of
unique stores attributed to an email address. OR if it is better to
use one of the many SUM options (which one?) to create an additional
column to