Hi -
We have reports that need to go out to a number of donors each year, some donors get multiple reports, while others only get 1. Each gift officer signs a cover letter for each household. So while a donor might appear several times in my sheet, there is only one signature needed.
Is there a formula/count that gives me the distinct count of the number of pieces needed to sign by a gift officer?
Example:
I don't want to display that Mike has to sign 4 letters when 3 of the 4 are going to the same household. Is there anything that can give me a distinct count based on those 2 columns?
