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