Re: $$Excel-Macros$$ Counting Unique Items

2010-10-11 Thread siti Vi
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 >

$$Excel-Macros$$ Counting Unique Items

2010-10-11 Thread MikeMikeMike
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