I am working on a report for a peer and had mostly completed it when I discovered an issue with one of my formulas.
I am using a dynamic named range to select a list of member numbers so that I can sum the results for all members in the list. The problem is that a member number may appear multiple times or multiple member numbers may appear in the list, so when used in a sumproduct function, it is multiplying results by the number of times each number appears in the list. Also, the member list has a variable amount of members list. One list may include three numbers, another may have 20, which is why I used a dynamic range.
I'm trying to find a way to make the dynamic named range only include each value in the Member List once. I have attached a sample file below.
Thank you for any help you can provide.
ExcelForum Sample.xlsx
Bookmarks