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 <michael.lovel...@gmail.com> wrote: > > 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 get the SUM I am looking for on WORKSHEET 2 and then use a > vlookup to pull that data into WORKSHEET 1? > > WORKSHEET 1 > Column1 = email address > Column2 = ****This is the column I want to show the number of unique > stores that are attributed to the email address**** (There is a many > to many relationship. Many email addresses can be attributed to many > stores.) > > WORKSHEET 2 - The stores. > Column1 = email address > Column2 = store_name > > Any help is most appreciated. > > Thank you! > > MikeMikeMike -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
ctv_Count of Unique Values.xls
Description: MS-Excel spreadsheet
