Hello,
Hope I can get some assistance on this.
I am trying to count unique values but only if amounts are >0. but in some cases, there are duplicates with different descriptions that need to be counted as 1 for the unique ID.
Examples are in the attached
1. If ID in Column C is >1 and Amounts in Column D is > 0 and the two descriptions are different, than count as 1 for that ID for True Count Column.
2. If ID >1 and there are different Descriptions Column A, Count ID as -1 for Amount less than 0 and 1 for Amount greater than 0. True Count for ID in this case should be zero
3. If duplicate ID and same Description. Count ID -1 for Amount less than 0 and 1 for Amount greater than 0. True count for ID should be zero.
Bookmarks