I am using a sumproduct (without the range to sum) to count a list of information that I have, but the issue that I am having is that because this list has everything that we carry and who we have sold it to, things appear in the list more than once. I only want to know how many different items we sold, not how many times we sold that item...is there anyway to get the formula to count only the first time that it encounters a style on the list? They all have different names so it is hard to say only count this, because I am wanting to do it for hundreds of different styles and thousands of sales.
Thanks in advace for the help
Chrysti
Thanks in advace for the help
Chrysti