I am trying to make a report a little more user friendly for a novice excel
user, and I am trying to use all formula's instead of pivotables on large
data sources. Is there a formula that will pull unique records out of a list
of customer #'s as an example without having to use auto filter which would
then require more manual intervention. I am then using sumproducts using the
customer number to create the report.