Dear All,
I am trying to avoid double counting two separate rows with the same columns. For example:
Stock Fund A Fund B Fund C Fund D Fund E Fund F Fund G Count Desired Count
LKOH 1 1 1 1 0 0 0 4 4
LKOH 0 0 1 1 1 1 0 4 2
If I have two stock codes the same in column A (not necessarily one below the other), I only want to count one of the occurrences per fund. So I would like to avoid counting the duplicate records for funds C and D. The desired outcome for the total holdings of LKOH should be 6 and not 8.
Any help as usual received with gratitude.
Thanks,Steve.
Bookmarks